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

322 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
curriers10341075(None) 
carriers103614201carriers
currier93316691currier_
curriery13326161curriery
curries93723161currie_s
furriers11369481furriers
hurriers11358891hurriers
barriers104311882barriers
buriers94017192bu_riers
burrers93814492burr_ers
burrier93613542burrier_
carrier93619582carrier_
carries94328012carrie_s
corries94026782corrie_s
couriers103213162couriers
courtiers1146682courtiers
criers83918582c__riers
curbers115514372cu_rbers
curdier103312612curdier_
curdlers11368492curdlers
curers84923182cu_r_ers
curies84934022cu_rie_s
curlers94218062cu_rlers
curlier93314182curlier_
currie84317252currie__
curried103313652currie_d
currieries1244532currieries
cursers94317152cu_rsers
curvier123110662curvier_
durries83817352durrie_s
farriers113610742farriers
furrier103513642furrier_
furriery14395672furriery
furriners12316302furriners
gurries83515952gurrie_s
harriers113712432harriers
hurrier103412932hurrier_
hurries103919652hurrie_s
marriers103312472marriers
murries94118672murrie_s
parriers103612902parriers
quarriers1845182quarriers
queriers1736962queriers
scurries102911482scurrie_s
spurriers11245062spurriers
tarriers83411712tarriers
terriers84210812terriers
worriers11257812worriers
arrivers11137003_arrivers
barrier94017733barrier_
berries94423553berrie_s
blurrier1035153blurrier_
briers85319733__briers
burblers12399263burblers
burdies104117563burdie_s
burgers103918573bu_rgers
burghers1435633burghers
burier84324653bu_rier_
buries84633273bu_rie_s
burkers133716623bu_rkers
burlers94120273bu_rlers
burlier93514413burlier_
burners94115673bu_rners
burnies94017823burnie_s
burrer83718473burr_er_
burriest102911213burriest
burritos1044473burritos
burrowers1483493burrowers
bursters1038983bursters
bustiers103810043bustiers
cahiers123510673c_ahiers
carders104820353c_arders
careers95218783c_areers
carers85133953c_ar_ers
caries85147623c_arie_s
carnies94123963carnie_s
carolers103314173carolers
carpers114521253c_arpers
carrels95117303carr_els
carried103717153carrie_d
carrions10312443carrions
carters95327243c_arters
carvers124817533c_arvers
cashiers13318883cashiers
catbriers1344143catbriers
chargers144011313chargers
charier124317903charier_
charmers154211323charmers
charrier1378683charrier_
charters134115563charters
cherries131812973cherrie_s
chirpers15358133chirpers
churners13316883churners
circlers1235343circlers
cirripeds1442053cirripeds
claries93422203clarie_s
claviers1367103claviers
codrivers1544863codrivers
coercers1237653coercers
colliers103613583colliers
copiers114215963c_opiers
corbies113520113corbie_s
corders104520873c_orders
corers85231073c_or_ers
corkers134118853c_orkers
corkier133114303corkier_
corners94723313c_orners
cornier93017083cornier_
coroners104016223coroners
corridas1177303corridas
corridors1245063corridors
corrie83621213corrie__
corulers1039763corulers
cottiers10399153cottiers
courier93617873courier_
coursers104412293coursers
courters103015363courters
courtier1059313courtier_
couturiers1243853couturiers
cowries124218013cowrie_s
cowriters14317273cowriters
craters95021883c_raters
cravers124416543c_ravers
crier74724463c__rier_
cries75438403c__rie_s
crosiers103312053crosiers
crowers124614893c_rowers
crozers184111083c_rozers
croziers19287003croziers
crucifers1643333crucifers
cruisers10438263cruisers
crullers1047293crullers
crumbers14338223crumbers
cruppers14317313cruppers
crushers134010083crushers
cubbies133312883cubbie_s
cubers105318343cu__bers
cuddies113313263cuddie_s
cuddlers12388383cuddlers
cullers93418843cu_llers
cullies94419963cullie_s
culvers12329823cu_lvers
cumbers134515393cu_mbers
cummers133713473cu_mmers
cunners93913463cu_nners
cupelers1266733cupelers
cuppers133712193cu_ppers
cuppier1368323cuppier_
cuprites1259023cuprites
curacies12311763curacie_s
curares94916853curare_s
curarines11710543curarines
curaris94114773curari__s
curarizes2078173curarizes
curates95323823curate_s
curators10311703curators
curber104517053cu_rber_
curbings13407313curbings
curches143512743curche_s
curdiest112511393curdiest
curdler103511563curdler_
curdles103814573curdle_s
cureless10319703cureless
curer75030753cu_r_er_
cures75645433cu_r_e_s
curets84922343cu_r_ets
curfews15294913cu_rfews
curie74533033cu_rie__
curios83218333cu_ri_os
curious93813563cu_rious
curites93919863cu_rites
curiums1138503cu_riums
curler85221323cu_rler_
curlews12387393cu_rlews
curliest102713113curliest
curliness1138553curliness
curlings114110383curlings
currachs1544543currachs
curraghs1442883curraghs
currans9310613curr_ans
currants1037933currants
curred94319263curr_e_d
current9313693curr_ent
currents1038373currents
curricle12145933curricle
curricles13105423curricles
curring103616843curri_ng
currish1238353curri_sh
currs75624393cu_r__rs
curser84721473cu_rser_
curses85328273cu_rse_s
cursives1337103cursives
cursors93910023cu_rsors
curtailers1243403curtailers
curter85320073cu_rter_
curtness1037263curtness
curtseys1342743curtseys
curtsies1038733curtsie_s
curves114619283cu_rve_s
curvets12399913cu_rvets
curviest13309673curviest
cushier123610833cushier_
cussers94213393cu_ssers
cuties84927363cu_tie_s
cutlers94216993cu_tlers
cutovers1335113cutovers
cutters94218953cu_tters
cutties93118843cuttie_s
decriers11299733decriers
derriere936043derriere
derrieres1044813derrieres
derries83124623derrie_s
dhurries1255583dhurrie_s
driers74516733__driers
durrie73713253durrie__
farrier103514883farrier_
farriery14295403farriery
ferries103521083ferrie_s
firrier103410123firrier_
flurries11188893flurrie_s
friers94718933__friers
fuhrers1334813fuhr_ers
furies95126373fu_rie_s
furlers104214223fu_rlers
furrieries1343933furrieries
furriest112910793furriest
furriner11267283furriner_
furriness12287593furriness
furrings12317123furrings
furrowers1563503furrowers
furthers1436493furthers
furzier19318093furzier_
guarders1035873guarders
harrier104417753harrier_
harries103525493harrie_s
herries104025073herrie_s
hurdies114015663hurdie_s
hurdlers12337493hurdlers
hurlers103714323hu_rlers
hurlies103315333hurlie_s
hurried113511043hurrie_d
hurters103413633hu_rters
jerries143817513jerrie_s
juries134120633ju_rie_s
kerries113317913kerrie_s
lorries74518343lorrie_s
lurchers13307153lurchers
lurers64217493lu_r_ers
lurkers113910083lu_rkers
luthiers1135163luthiers
marrers93414313marr_ers
marrieds11288073marrieds
marrier93817523marrier_
marries93825283marrie_s
merrier92612303merrier_
murders103311363mu_rders
murkier133110263murkier_
murres85019043murr_e_s
murreys12367323murr_eys
murthers1336543murthers
nursers74311833nu_rsers
outliers82610673outliers
outriders10237223outriders
parrier93717653parrier_
parries93925843parrie_s
partiers103514243partiers
perries93226603perrie_s
priers84521193__priers
purflers13216963purflers
purgers104714003pu_rgers
purifiers1435873purifiers
purlieus1034633purlieus
pursers93916093pu_rsers
pursier94012753pursier_
pursuers10376523pursuers
purtier93214093purtier_
purviews1642533purviews
puttiers10288013puttiers
quarrier1736843quarrier_
quarries1749943quarrie_s
quarters173110443quarters
quartiers1845183quartiers
querier16310013querier_
queries16315873querie_s
scarrier10298453scarrier_
scurfier13267053scurfier_
scurried11267053scurrie_d
scurvier13255883scurvier_
scurvies13248123scurvie_s
serries73925353serrie_s
slurries82710413slurrie_s
sorrier72313723sorrier_
spurrers10338453spurr_ers
spurrier10297683spurrier_
spurries102311323spurrie_s
surfers103614133su_rfers
surfier102613543surfier_
surgers83517483su_rgers
surlier72915443surlier_
surmisers1145203surmisers
surprisers1243633surprisers
surreys10489433surr_eys
survivers1543883survivers
tarrier74323173tarrier_
tarries73324263tarrie_s
tarsiers8298533tarsiers
terrier73414963terrier_
terries73425613terrie_s
triers64321523__triers
turfier10249793turfier_
turners73912893tu_rners
turrets73010673turr_ets
turtlers8258203turtlers
uprisers10206773_uprisers
uprivers13215563_uprivers
ureters7311823_ureters
urgers73313623_u_rgers
variers103712663_variers
verniers11227843verniers
warriors1135363warriors
worrier102311673worrier_
worries104117133worrie_s

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.1561145455.1
2DLD Change Limit1461623227.22020244.0
3Display Results3223220.1402300.0
 (SQL Overall)1786913227.51623774.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.