Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “crimp” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
crimp11561580(None) 
chimp145216471chimp
cramp115120691cramp
crime94822691crime
crimps124613451crimps
crimpy15489391crimpy
crisp95014621crisp
crump115616421crump
primp115615921primp
scrimp125110581scrimp
blimp115612942blimp
brim85629372brim_
brims94721622brims
camp106336452c_amp
champ145017962champ
chimb144813562chimb
chime125322592chime
chimps155713662chimps
chip116726422chi_p
chirp124717162chirp
chomp144815662chomp
chump145315442chump
clamp115517652clamp
climb115413592climb
clime95720892clime
clip86924002cli_p
clomp115615702clomp
clump115517452clump
comp106731252c_omp
cram85635492cram_
cramps125615562cramps
crampy154710992crampy
crams96229152crams
crap85731842cr_ap
creep95218102creep
creme94319322creme
crib86323582cri_b
cribs94516752cribs
crick135118752crick
cried84624282cried
crier74724462crier
cries75438402cries
crimes105521582crimes
crimped143910762crimped
crimper136510422crimper
crimple13408692crimple
cripe95521142cripe
cris66233432cri_s
crisps104411512crisps
crispy13478562crispy
crit65743712cri_t
crits75527572crits
crop87628632cr_op
croup95616782croup
crumb114313592crumb
crumps124514342crumps
drip76223952dri_p
frump126912562frump
gimp96124042_gimp
gramp106218322gramp
grim76929422grim_
grime85021322grime
grimy114312602grimy
grip76127022gri_p
grump105115312grump
imp76626972__imp
jimp155618462_jimp
limp88432492_limp
pimp106024902_pimp
prim85132202prim_
prima95019342prima
prime96525602prime
primi95017402primi
primo95017912primo
primps124711822primps
prims95425932prims
ramp85934002_ramp
rim56052272_rim_
rime65138882_rime
rims65936302_rims
rimy96621282_rimy
rip56851302_ri_p
romp85926572_romp
rump86729082_rump
scrim95419742scrim_
scrimps13517902scrimps
scrimpy16486132scrimpy
scrims104615932scrims
scrip96619192scri_p
shrimp13478772shrimp
simp85228772_simp
skimp135411322skimp
tramp96319772tramp
trim65329522trim_
trims75021472trims
trip66830392tri_p
tromp95815802tromp
trump95615122trump
wimp115521522_wimp

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691538000.296603685.8
2DLD Change Limit53800991.54634799.5
3Display Results99990.0333000.0
 (SQL Overall)178691991.87595301.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.