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

247 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
hurriers1135889(None) 
curriers103410751curriers
furriers11369491furriers
harriers113712431harriers
hurrier103412941hurrier_
hurries103919651hurrie_s
barriers104311882barriers
buriers94017192bu_riers
burrers93814492burr_ers
burrier93613552burrier_
carriers103614202carriers
currier93316702currier_
curriery13326162curriery
curries93723162currie_s
dhurries1255582dhurrie_s
durries83817352durrie_s
farriers113610742farriers
furrier103513662furrier_
furriery14395682furriery
furriners12316322furriners
gurries83515952gurrie_s
harrier104417752harrier_
harries103525492harrie_s
herries104025072herrie_s
hurdies114015662hurdie_s
hurdlers12337492hurdlers
hurlers103714322hu_rlers
hurlies103315332hurlie_s
hurried113511042hurrie_d
hurters103413642hu_rters
marriers103312472marriers
murries94118672murrie_s
parriers103612902parriers
quarriers1845182quarriers
queriers1736962queriers
spurriers11245062spurriers
tarriers83411712tarriers
terriers84210822terriers
worriers11257812worriers
arrivers11137003_arrivers
barrier94017733barrier_
berries94423553berrie_s
blurrier1035163blurrier_
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
bustiers103810053bustiers
carrier93619583carrier_
carries94328013carrie_s
charrier1378683charrier_
cherries131812983cherrie_s
churners13316893chu_rners
corries94026793corrie_s
couriers103213173couriers
courtiers1146693courtiers
criers83918583__criers
curbers115514383cu_rbers
curdier103312623curdier_
curdlers11368493curdlers
curers84923193cu_r_ers
curies84934023cu_rie_s
curlers94218073cu_rlers
curlier93314183curlier_
currie84317263currie__
curried103313653currie_d
currieries1244533currieries
cursers94317163cu_rsers
curvier123110663curvier_
decriers11299733decriers
derriere936043derriere
derrieres1044813derrieres
derries83124623derrie_s
dhurrie1153953dhurrie__
driers74516733__driers
durrie73713263durrie__
farrier103514893farrier_
farriery14295403farriery
ferries103521083ferrie_s
firrier103410133firrier_
flurries11188913flurrie_s
friers94718933__friers
fuhrers1334813fuhr_ers
furies95126373fu_rie_s
furlers104214223fu_rlers
furrieries1343943furrieries
furriest112910793furriest
furriner11267303furriner_
furriness12287603furriness
furrings12317143furrings
furrowers1563503furrowers
furthers1436493furthers
furzier19318103furzier_
gharries12318203gharrie_s
guarders1035883guarders
hagriders1443553hagriders
hairier103111053hairier_
hardier114721543hardier_
hardies114923233hardie_s
harmers124116593h_armers
harpers124916203h_arpers
harpies123818323harpie_s
harried113815533harrie_d
harrowers1555683harrowers
hauliers1176713hauliers
hearers104319783hear_ers
henries102718283henrie_s
herbier1239593herbier_
herders113914123h_erders
herried113514453herrie_d
herrings12379533herrings
hirers94518063h_ir_ers
hoarders12307433hoarders
hoarier104211743hoarier_
hornier103012463hornier_
horrider1236533horrider_
horrors1078693horr_ors
horsier103013243horsier_
hosiers104212643h_osiers
hourlies1138343hourlie_s
hubbies143211563hubbie_s
hubris11218973hubri__s
hubrises1337103hubrises
huddlers13337633huddlers
huffier1637493huffier_
huggers124211593hu_ggers
hulkier14328973hulkier_
hullers103616263hu_llers
humblers15379803humblers
hummers143813063hu_mmers
humpers142713523hu_mpers
humpier143110723humpier_
hungers114013303hu_ngers
hungrier1233893hungrier_
hunkers143314333hu_nkers
hunkier144512143hunkier_
hunkies143214503hunkie_s
hunters103915733hu_nters
hurdler113610003hurdler_
hurdles113613373hurdle_s
hurler94717223hu_rler_
hurleys13407333hu_rleys
hurlings12388213hurlings
hurrahs13336773hurr_ahs
hurrays13386153hurr_ays
hurriedly1642503hurriedly
hurter93915853hu_rter_
hurtles103913753hurtle_s
hurtless11307783hurtless
huskers143510043hu_skers
huskier14369763huskier_
huskies143212083huskie_s
hussies103213293hussie_s
hustlers11349203hustlers
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
murkier133110273murkier_
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
quarters173110453quarters
quartiers1845183quartiers
querier16310013querier_
queries16315873querie_s
scurries102911483scurrie_s
serries73925353serrie_s
sherries111812893sherrie_s
slurries82710413slurrie_s
sorrier72313733sorrier_
spurrers10338463spurr_ers
spurrier10297693spurrier_
spurries102311323spurrie_s
surfers103614133su_rfers
surfier102613543surfier_
surgers83517483su_rgers
surlier72915443surlier_
surmisers1145203surmisers
surprisers1243633surprisers
surreys10489443surr_eys
survivers1543883survivers
tarrier74323173tarrier_
tarries73324263tarrie_s
tarsiers8298533tarsiers
terrier73414963terrier_
terries73425633terrie_s
thurifers1542913thurifers
triers64321523__triers
turfier10249793turfier_
turners73912893tu_rners
turrets73010673turr_ets
turtlers8258203turtlers
uprisers10206773_uprisers
uprivers13215563_uprivers
ureters7311823_ureters
urgers73313623_u_rgers
variers103712663_variers
verniers11227843verniers
warriors1135363warriors
wherries14179023wherrie_s
whirries14136693whirrie_s
worrier102311683worrier_
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.420425454.8
2DLD Change Limit1461622476.84621350.0
3Display Results2472470.1062330.2
 (SQL Overall)1786912477.37224239.1
 
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.