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

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

271 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
currish123835(None) 
burnish1238622burnish
carlish12312772carlish
cherish15310462cherish
churlish1644902churlish
cubbish1635802cubbish
cuish10313172cu__ish
cultish12139112cultish
curaris94114772curaris_
currach1446452currach
curragh1344292curragh
currie84317262curri_e
curried103313652curried
currier93316702currier
curries93723162curries
curring103616842curring
currishly1763942currishly
currs75624392curr_s_
furbish1536442furbish
furnish1337382furnish
actorish1349453actorish
arris56824683_arris_
auris55331533au_ris_
aurist65027253au_rist
bearish123013273bearish
boarish123911913boarish
boorish123712593boorish
brutish1237703brutish
buckish18237883buckish
bullish12511193bullish
bulrush1243593bulrush
burrier93613553burrier
burriest102911213burriest
burring104016993burring
burrito936223burrito
burros85114993burros_
burrs74925653burr_s_
caddish143810133caddish
capris10415083capris_
carried103717153carried
carrier93619583carrier
carries94328013carries
carrion9312673carrion
carritch1543483carritch
carroch1437093carroch
carrs75730853carr_s_
carwash1536003carwash
catfish1559023catfish
cattish12410723cattish
ceorlish1345383ceorlish
cercis104614493cercis_
ceriph1398463c_eriph
cerise84822043c_erise
charism14712203charism
chrism13710673c_hrism
churring14298653churring
churros12427583churros_
churrs115111513churr_s_
cirri7710723cirri__
cirrose937473cirrose
cirrus8349173cirrus_
clayish1547943clayish
clerisy1246823clerisy
clerkish1744263clerkish
clubbish1743813clubbish
clumpish17164893clumpish
cockish1838503cockish
codfish1637163codfish
coldish1399303coldish
coltish121310933coltish
coolish12312523coolish
corgis9314413corgis_
corrida1078523corrida
corrie83621233corri_e
corries94026803corries
cowfish1836433cowfish
coyish143710393c_oyish
crash109120013c__rash
creesh11328333c_reesh
cris66233433c__ris_
crisp95014623c__risp
cronish12310863cronish
cruise84314043c_ruise
crush106815993c__rush
cubism12348703cu_bism
cubist104214443cu_bist
cuirass934973cuirass
cullis84115993cullis_
cultism11158003cultism
cultist91412713cultist
cupric1249123cupri_c
cuprite1159683cuprite
curagh1236553cu_ragh
curaghs1334583curaghs
curaras93911953curaras_
curares94916853curares_
curari84414403curari__
curarine10610713curarine
curarize1988853curarize
curbing123814023curbing
curbs94821653cu_rbs_
curch124415413cu_r_ch
curdier103312623curdier
curdiest112511393curdiest
curding113515133curding
curds85725613cu_rds_
curers84923193curers_
cures75645433cu_res_
curets84922343curets_
curfs105122143cu_rfs_
curia74523783cu_ri_a
curiae84518373cu_riae
curial84019153cu_rial
curie74533043cu_ri_e
curies84934023cu_ries
curing94824783cu_ring
curio74221213cu_ri_o
curios83218333cu_rios
curiosa9346643curiosa
curite85222943cu_rite
curium10312503cu_rium
curlier93314183curlier
curliest102713123curliest
curlily1238383curlily
curling104320183curling
curls74927103cu_rls_
curns74924283cu_rns_
curr65429653curr___
currachs1544543currachs
curraghs1442883curraghs
curran8312023curr_an
currans9310613currans
currant9314173currant
curred94319263curr_ed
current9313693current
curricle12145933curricle
curriers103410753curriers
curriery13326163curriery
curry105920343curr__y
currying14196493currying
curs65645543cu_r_s_
curse75829143cu_r_se
curses85328273curses_
cursing104217033cursing
cursive1237833cursive
curst74931023cu_r_st
curtest9713963curtest
curtesy1265833curtesy
curtsy1156643cu_rtsy
curves114619283curves_
curvier123110663curvier
curviest13309673curviest
curving133912103curving
cuspis105010703cuspis_
cutis77723763cu_tis_
czarism2056423czarism
czarist18710223czarist
darkish1537943darkish
derris73615273derris_
dervish1436983dervish
dryish1336323_dryish
dudish1148313du_dish
dullish1148743dullish
dumpish15116113dumpish
duncish1335793duncish
durras74713373durras_
durrie73713263durri_e
durries83817353durries
durrs65519993durr_s_
duskish1535183duskish
fairish1338993fairish
furrier103513663furrier
furriest112910793furriest
furrily1337613furrily
furring114013143furring
garfish14179203garfish
garish104516933_garish
garnish111610853garnish
girlish1137193girlish
gurries83515953gurries
gursh94512333gu_r_sh
hubris11218973hubris_
huffish1935713huffish
hunnish1336163hunnish
hurrah12369183hurr_ah
hurrahs13336773hurrahs
hurried113511043hurried
hurrier103412943hurrier
hurries103919653hurries
jurist134616393ju_rist
kukris934453kukris_
kurbash1643803kurbash
largish1138603largish
larkish1439083larkish
lumpish14127383lumpish
marish114319063_marish
moorish123311783moorish
morris83814733morris_
mudfish1646263mudfish
mulish11311903mu_lish
murras84916013murras_
murres85019043murres_
murries94118673murries
murrine9411483murrine
murrs75521303murr_s_
nerdish1137103nerdish
noirish1037883noirish
nourish1039703nourish
nunnish1035933nunnish
oarfish13158613oarfish
ogreish1134673ogreish
ogrish1039263_ogrish
orris54516553_orris_
ouraris73512933ouraris_
outfish132210573outfish
outrush1037043outrush
outwish13289853outwish
parish115022363_parish
perish114619063_perish
perkish16258823perkish
poorish123712303poorish
prudish1376563prudish
publish1447913publish
puckish18237213puckish
puggish14265993puggish
punish111411513pu_nish
punkish16257693punkish
pupfish1735533pupfish
puris75332023pu_ris_
purism104715063pu_rism
purist85525053pu_rist
purplish1554933purplish
purring104515823purring
purrs75320433purr_s_
queerish2045313queerish
querist16311133querist
quirkish2442993quirkish
qursh174110843qu_r_sh
qurush1835503qu_rush
rubbish1436303rubbish
runtish1048693runtish
ruttish1048303ruttish
scurried11267053scurried
scurries102911483scurries
scurril945113scurri_l
scurrile1055073scurrile
serfish1348973serfish
sourish10310693sourish
squarish2047323squarish
squirish2045113squirish
sunfish1338883sunfish
sunrise7310813sunrise
surffish1744783surffish
surmise9311083surmise
surprise1037673surprise
surras65919533surras_
tarnish101611883tarnish
tartish101512633tartish
tigrish1137573tigrish
tundish1137283tundish
turbith1267113turbith
unwish1239093_unwish
uppish1336633_uppish
uprise82313693_uprise
uprush1135783_uprush
uraris63817273_uraris_
varnish13169553varnish
warmish1538373warmish
wearish132310153wearish
whorish1636603whorish
wormish1537163wormish

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340272716.17321711.8
3Display Results2712710.1062556.6
 (SQL Overall)1786912716.66926794.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.