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

407 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
querier1631001(None) 
queried1738681queried
queriers1736961queriers
queries16315871queries
aerier64823152_aerier
beerier93613022beerier
burier84324652bu_rier
burrier93613552burrier
currier93316702currier
eerier64320022_eerier
fierier103511192fierier
furrier103513662furrier
hurrier103412942hurrier
leerier73111502leerier
onerier7311612onerier
quakier20239202quakier
quarrier1736842quarrier
quarter163211852quarter
quartier1737542quartier
queasier1734472queasier
queazier2642832queazier
queer143712812que__er
queerer16106502queerer
queller16289292queller
querida1744352querida
querist16311132querist
quester161410022quester
queuer15357252que_uer
quirkier2134162quirkier
verier94620962_verier
acerber1135243acerber
aerie54634603_aerie_
aeried74221863_aeried
aeries64737783_aeries
airier64619363_airier
alerter72111513alerter
amercer1146373amercer
angrier839023angrier
aperies9423203aperies
atelier7311623atelier
averter102410553averter
barrier94017733barrier
beefier12329093beefier
belier84423563_belier
blearier1037333blearier
bluesier1034943bluesier
blurrier1035163blurrier
brevier1237763brevier
brier74527403__brier
buffier1568403buffier
buggier113611343buggier
bulgier103911213bulgier
bulkier134111513bulkier
bullier94116433bullier
bumpier13359203bumpier
burger94020793bu_rger
buried94822373bu_ried
buriers94017193bu_riers
buries84633273bu_ries
burker125221173bu_rker
burler84723833bu_rler
burlier93514413burlier
burner83819203bu_rner
burrer83718473bu_rrer
bushier123712813bushier
busier85219723bu_sier
bustier93916153bustier
butterier1177453butterier
carrier93619583carrier
charier124317903charier
cheerier1348003cheerier
chertier1387873chertier
chewier1537593chewier
coercer1138383coercer
courier93617893courier
crepier1139743crepier
crier74724463__crier
cuppier1368323cuppier
curber104517053cu_rber
curdier103312623curdier
curer75030753cu_r_er
curie74533043cu_rie_
curies84934023cu_ries
curler85221323cu_rler
curlier93314183curlier
currie84317263currie_
curried103313653curried
curriers103410753curriers
curriery13326163curriery
curries93723163curries
curser84721473cu_rser
curter85320083cu_rter
curvier123110663curvier
cushier123610833cushier
cutesier1045623cutesier
decrier102713553decrier
deedier93011593deedier
defier105118653_defier
denier74420693_denier
derider93214973_derider
deriver114213913_deriver
dernier83011943_dernier
dewier104013463_dewier
drearier9297923drearier
drier64423963__drier
duckier143911793duckier
dueler74213683due_ler
dueller8329833dueller
dumpier12409653dumpier
dungier9368583dungier
duperies11312813duperies
durrie73713263durrie_
durries83817353durries
duskier12409433duskier
dustier83814133dustier
eelier64216463_eelier
eerie55228533_eerie_
emeries91620023emeries
equerries1844883equerries
faerie93514683faerie_
faeries104118993faeries
farrier103514893farrier
fernier103110823_fernier
fiercer12356953fiercer
firrier103410133firrier
frier85225843__frier
fubsier12367763fubsier
fuehrer1332973fuehrer
fueler94313933fue_ler
fueller10279963fueller
fuggier12348963fuggier
fuhrer1235033fuhr_er
fumier11310903fu_mier
funkier14349983funkier
funnier103210173funnier
furies95126373fu_ries
furler93616403fu_rler
furriers11369493furriers
furriery14395683furriery
furriner11267303furriner
furzier19318103furzier
fussier103610673fussier
fustier104213933fustier
fuzzier18256523fuzzier
geekier12286393geekier
germier10309543_germier
glarier84112213glarier
gorier73719373_gorier
guarder936463guarder
guesser8166543guesser
gulfier1137793gulfier
gulpier1046953gulpier
gummier12349473gummier
gunkier12369553gunkier
gurries83515953gurries
gushier113110073gushier
gustier83813863gustier
gutsier8389823gutsier
guttier83911103guttier
hairier103111053hairier
harrier104417753harrier
herbier1239593_herbier
herder104516463_herder
hoarier104211743hoarier
huffier1637493huffier
hulkier14328973hulkier
humpier143110723humpier
hungrier1233893hungrier
hunkier144512143hunkier
hurler94717223hu_rler
hurried113511043hurried
hurriers11358893hurriers
hurries103919653hurries
hurter93915853hu_rter
huskier14369763huskier
jeerer13389933jeer_er
jerker17369043_jerker
jerkier18407273_jerkier
juicier1635463juicier
jumpier18317943jumpier
junkier18339493junkier
juried144212443ju_ried
juries134120633ju_ries
learier73415663learier
levier94013873_levier
liquefier2142303liquefier
luckier133811533luckier
lumpier113410143lumpier
lunier64617603lu_nier
lurer54625313lu_r_er
lurker103613293lu_rker
lustier73813503lustier
luthier1038233luthier
marrier93817523marrier
mercer105214203_mercer
merer75126233_mer_er
merger95016483_merger
merrier92612303merrier
metier83517693_metier
mirier83918363_mirier
moorier93113073moorier
muckier153411483muckier
muddier114110023muddier
muggier11288943muggier
murder93613783mu_rder
murker123715243mu_rker
murkier133110273murkier
murries94118673murries
mushier123813593mushier
muskier134312733muskier
mussier93314363mussier
mustier94017963mustier
muzzier17326553muzzier
needier84010623needier
nerdier83110353_nerdier
nervier10298833_nervier
nubbier11308133nubbier
nurser64314503nu_rser
nutsier7329253nutsier
nuttier73112023nuttier
ornerier846043ornerier
ourie54027303ou_rie_
outlier72216143outlier
outrider92410563outrider
parrier93717653parrier
peerie83617893peerie_
peeries93623023peeries
perkier133813123_perkier
perter84422283_perter
piercer11337773piercer
premier113515633premier
prier75027763__prier
puckerier1754313puckerier
pudgier11377723pudgier
puerile9310093puerile
puerpera1242853puerpera
puffier1547973puffier
puggier11309383puggier
pulpier1148623pulpier
punier84519223pu_nier
punkier133512793punkier
punnier93511263punnier
purer75127903pu_r_er
purger94717233pu_rger
purser85020473pu_rser
pursier94012753pursier
purtier93214093purtier
pushier123611093pushier
pussier93711993pussier
puttier93314503puttier
quackier23215373quackier
quaere154110673quaer_e_
quaeres163310843quaer_es
quaffer2235133quaffer
quaggier1933853quaggier
quaker193811623qu_aker
qualmier1934563qualmier
quare143920543quar_e_
quarrel1636103quarrel
quarried1836093quarried
quarriers1845183quarriers
quarries1749943quarries
quarte154115323quarte_
quartern17286473quartern
quarters173110453quarters
quartes163314933quartes
quartet162814893quartet
quartiers1845183quartiers
quasher19198623quasher
quaver18309313qu_aver
quaverer2054583quaver_er
queen144312063que__en
queened17105863queened
queenlier1842123queenlier
queered17117213queered
queering1838203queering
queerish2045313queerish
queers153510773que__ers
quelea1547303que_lea
quelled17279273quelled
quellers17237533quellers
quencher2234123quencher
quercine1964863quercine
queridas1843863queridas
querists1736543querists
quern143610403quer__n
querns15307943quer_ns
query174212083quer__y
querying2135243querying
quested17168383quested
questers17168763questers
questor16146633questor
queue143711233que_ue_
queued16336943que_ued
queuers16366393que_uers
queues153510193que_ues
queuing1736233queuing
quicker2247023quicker
quiet144530733qu__iet
quieter162810333quieter
quilter16279803quilter
quipper2095823quipper
quippier2133773quippier
quire144917133quir_e_
quired163711953quir_ed
quires154015753quir_es
quiring17159993quiring
quirked21325433quirked
quirted17369213quirted
quitter162910753quitter
quiver18278743qu_iver
quiverer2044463quiver_er
quizzer2434393quizzer
quoter153510093qu_oter
reedier83815303reedier
reefier102912553reefier
reekier113111123reekier
relier65826183_relier
rubberier1344393rubberier
rubier84814743ru_bier
ruddier9338523ruddier
ruderies9311333ruderies
rulier65016353ru_lier
rummier11309563rummier
runnier74010113runnier
runtier73512853runtier
rushier103411973rushier
rustier74416363rustier
ruttier73412283ruttier
scarier94017873scarier
seedier83513633seedier
seepier92912013seepier
serer55935513_ser_er
serger73819743_serger
series64540973_series
server94917713_server
sexier13310683_sexier
smearier1036953smearier
sneerier878103sneerier
sorrier72313733sorrier
spherier1337783spherier
spirier93214073spirier
sprier84119063_sprier
spurrier10297693spurrier
squarer163410663squar_er
squeaker2184883squeaker
squeakier2242903squeakier
squealer17115603squealer
squeezer2643373squeezer
squirmer1934373squirmer
squirmier2042853squirmier
squirter1746523squirter
sterner7411913sterner
suckier133613973suckier
sudsier868783sudsier
sugarier937393sugarier
sulkier113811963sulkier
sultrier837773sultrier
summerier1346423summerier
sunnier73412153sunnier
superber1239693superber
superior10310883superior
surer54833103su_r_er
surfer93515883su_rfer
surfier102613543surfier
surger74320093su_rger
surlier72915443surlier
swerver1365733swerver
tarrier74323173tarrier
tearier73815613tearier
teenier72611143teenier
termer85717253_termer
terrier73414963terrier
terser67317823_terser
thewier1336063thewier
towerier1137123towerier
trier54328533__trier
tubbier11237743tubbier
tuftier1096603tuftier
turfier10249793turfier
turner63914613tu_rner
uglier748953_uglier
unriper9188283_unriper
upriser9218763_upriser
upriver12196933_upriver
ureter6313203_ureter
urger64116473_u_rger
varier94619353_varier
veeries102916893veeries
verger104315703_verger
vernier102711273_vernier
verser94516963_verser
viewier1334983viewier
vuggier12296813vuggier
warier93722893_warier
waterier11312083waterier
wearier103613283wearier
weedier113810623weedier
weenier103210803weenier
weepier12319273weepier
wirier94215553_wirier
worrier102311683worrier
wrier84521753__wrier
wussier10408083wussier
yuckier16358533yuckier
yukkier13263893yukkier
yummier14306843yummier

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 Filter1786911340270.406440125.6
2DLD Change Limit1340274076.50020619.5
3Display Results4074070.1562609.0
 (SQL Overall)1786914077.06225303.2
 
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.