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 “curriery” 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.

131 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
curriery1332616(None) 
currier93316701currier_
curriers103410751curriers
furriery14395681furriery
burrier93613552burrier_
carrier93619582carrier_
carriers103614202carriers
curdier103312622curdier_
curlier93314182curlier_
currie84317262currie__
curried103313652currie_d
curries93723162currie_s
curvier123110662curvier_
farriery14295402farriery
furrier103513662furrier_
furriers11369492furriers
hurrier103412942hurrier_
hurriers11358892hurriers
barrier94017743barrier_
barriers104311883barriers
blurrier1035163blurrier_
briery114510773__briery
burier84324653bu_rier_
buriers94017193bu_riers
burlier93514413burlier_
burrer83718473burr_er_
burrers93814493burr_ers
burriest102911213burriest
carried103717153carrie_d
carries94328013carrie_s
charier124317903charier_
charrier1378693charrier_
colliery13307363colliery
corkier133114303corkier_
cornier93017093cornier_
corrie83621233corrie__
corries94026803corrie_s
courier93617893courier_
couriers103213173couriers
courtier1059333courtier_
courtiers1146703courtiers
crier74724463c__rier_
criers83918583c__riers
cuppier1368323cuppier_
curber104517053cu_rber_
curbers115514383cu_rbers
curdiest112511393curdiest
curdler103511563curdler_
curdlers11368493curdlers
curer75030753cu_r_er_
curers84923193cu_r_ers
curie74533043cu_rie__
curies84934023cu_rie_s
curler85221323cu_rler_
curlers94218073cu_rlers
curliest102713123curliest
curlily1238383curli_ly
curred94319263curr_e_d
currency1545543currency
current9313693curr_ent
curricle12145933curricle
currieries1244543currieries
curring103616843curri_ng
currish1238353curri_sh
currishly1763943currishly
curry105920343cu_r__ry
curser84721473cu_rser_
cursers94317163cu_rsers
cursively1744993cursively
cursory12406393cu_rsory
curter85320083cu_rter_
curtesy1265833cu_rtesy
curtsey1255013curtse_y
curvey144111843cu_rve_y
curviest13309673curviest
cushier123610833cushier_
cutchery18265173cutchery
cutlery12448393cu_tlery
derriere936043derriere
durrie73713263durrie__
durries83817353durrie_s
farrier103514893farrier_
farriers113610743farriers
firrier103410133firrier_
furriest112910793furriest
furrily1337613furri_ly
furriner11267303furriner_
furriners12316323furriners
furzier19318103furzier_
gurries83515953gurrie_s
harrier104417763harrier_
harriers113712433harriers
hurried113511043hurrie_d
hurriedly1642503hurriedly
hurries103919653hurrie_s
marrier93817523marrier_
marriers103312473marriers
merrier92612303merrier_
murkier133110273murkier_
murrey114312263murr_e_y
murries94118673murrie_s
nursery10396023nu_rsery
orrery936783_orr_ery
parrier93717653parrier_
parriers103612903parriers
pursier94012753pursier_
purtier93214093purtier_
quarrier1736843quarrier_
quarriers1845183quarriers
querier16310013querier_
queriers1736963queriers
scarrier10298453scarrier_
scurfier13267053scurfier_
scurried11267053scurrie_d
scurries102911483scurrie_s
scurvier13255883scurvier_
sorrier72313733sorrier_
spurrier10297693spurrier_
spurriers11245063spurriers
surfier102613543surfier_
surgery11319213su_rgery
surlier72915443surlier_
surrey94414583surr_e_y
tarrier74323173tarrier_
tarriers83411713tarriers
terrier73414963terrier_
terriers84210823terriers
turfier10249793turfier_
turnery10357423tu_rnery
worrier102311683worrier_
worriers11257813worriers

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621316.96620982.2
3Display Results1311310.0502620.0
 (SQL Overall)1786911317.43924020.8
 
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.