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 “crib” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

143 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
crib8632358(None) 
crab85727671crab
cribs94516751cribs
cris66233431cris
crit65743711crit
drib76823261drib
rib56848031_rib
acrid86920102acrid
arb510448422ar_b
aria46245422aria
arid57642712arid
aril45843022aril
bib77045942_bib
bribe94820782bribe
brie65837902brie
brig76528032brig
brim85629372brim
brin67038192brin
brio65432492brio
bris65539612bris
brit66350152brit
cab78355402c_ab
caid77837532caid
cain65643912cain
carb85143162carb
caribe103416752caribe
carob95325222carob
ceiba938702ceiba
ceil65725062ceil
ceria75125352ceria
ceric94023092ceric
chi86228652chi_
chia96026622chia
chic115925202chic
chid106626402chid
chimb144813562chimb
chin96934742chin
chip116726422chip
chis95933312chis
chit96937462chit
chub115516412chub
cig67036182c_ig
cire65836372cire
cis57748032c_is
climb115413592climb
clip86924002clip
club85819472club
cob710258752c_ob
cobb106422002cobb
coif96337912coif
coil66439652coil
coin66645352coin
coir66327242coir
comb106632112comb
coria75828322coria
crabs95421392crabs
crag75625302crag
cram85635492cram
crap85731842crap
craw97725262craw
cred76530882cred
crew96122682crew
crick135118752crick
cried84624282cried
crier74724462crier
cries75438402cries
crime94822692crime
crimp115615802crimp
cripe95521142cripe
crisp95014622crisp
crits75527572crits
croc85723732croc
crop87628632crop
crow96428132crow
cru57129562cr_u
crud75219612crud
crumb114313592crumb
crus65828482crus
crux135415002crux
cry89726242cr_y
cub76940942c_ub
cuif96529142cuif
curb86732222curb
curia74523772curia
curie74533042curie
curio74221212curio
dib65746942_dib
drab76226452drab
dribs85115062dribs
drip76223952drip
drub75920132drub
fib86344272_fib
frig85424502frig
frit77044472frit
friz166324342friz
gib66443532_gib
glib79421442glib
grab75427612grab
grid65829612grid
grig65424772grig
grim76929422grim
grin55733722grin
grip76127022grip
grit55247242grit
grub77220082grub
irid55927172irid
iris45732552iris
jib125835972_jib
kris86423602kris
lib57750272_lib
mib76946122_mib
nib56745192_nib
orb55736862or_b
oribi7311092oribi
prig75924872prig
prim85132202prim
reb55844962_reb
ria36745502_ria
ribs65833022_ribs
rid46754632_rid
rif65951562_rif
rig46748122_rig
rim56052272_rim
rin36663182_rin
rip56851302_rip
rob56754302_rob
rub56342822_rub
scribe104613532scribe
scrim95419742scrim
scrip96619192scrip
scrub94914202scrub
sib56850312_sib
snib66522982snib
sri35634002sri_
sris45434152sris
tribe74420272tribe
trig55528162trig
trim65329522trim
trio45233342trio
trip66830392trip
urb55731112ur_b
uric63624942uric
writ75537912writ

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 Filter178691298720.266671770.7
2DLD Change Limit298721430.90632971.3
3Display Results1431430.0304766.7
 (SQL Overall)1786911431.202148661.4
 
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.