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

419 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
quatre15351236(None) 
quaere154110681quaere
quare143920541qua_re
quarte154115331quarte
quate144521411quat_e
quatres163411941quatres
cuatro838432cuatro
equate152012462equat_e
lustre64011682lustre
outre53922202ou_tre
quaeres163310852quaeres
quake184114642qua_ke
quaker193811622quaker
quale143617852qua_le
quark184614122qua_rk
quarrel1636112quarrel
quarry1837472quarry
quart144027852qua_rt
quarter163211862quarter
quartes163314942quartes
quartet162814902quartet
quarto153511122quarto
quarts154715942quarts
quartz244212102quartz
quatorze2642952quatorze
quaver18309312quaver
quire144917132qu_ire
quite144621462quit_e
quote143714772quot_e
quoter153510092quoter
square154513362squa_re
abate76627843abat_e
abater85518123abater
acre67330773__acre
acuate8315633acuat_e
agate66525153agat_e
alate55340333alat_e
antre55224523_antre
aquae142212713aqua__e
aquatic1838113aquatic
aquatone1744913aquatone
are37874573__a_re
ate37059243__at_e
auntie64317703auntie
aurate64426473aurat_e
austere7312993austere
aware86420023awa_re
bare65460523_ba_re
barre75929553_barre
bate66552423_bat_e
bathe105822883_bathe
beater84729393beater
bistre83815023bistre
blare75826233bla_re
blate75933783blat_e
boater84622093boater
bunter85020383bunter
buster84726493buster
bustle84015483bustle
butane8313653butane
bute66739673bu_t_e
butle75023103bu_tle
butte74924293bu_tte
butter84724233butter
cadre85419023_cadre
care66968373_ca_re
carte75940423_carte
cate66254603_cat_e
cater74840723_cater
centre84316643centre
chare105231983cha_re
coatee84327223coatee
coater84329573coater
crate76537403crat_e
crater85026643crater
cuatros938273cuatros
cubature1244693cubature
culture939393culture
curare84916953curare
curate85226243curat_e
cure66149123cu__re
curter85320083curter
cute66440453cu_t_e
cuter74728233cu_ter
cutie76925933cu_tie
cutter84521003cutter
cuttle84113893cuttle
dare55848863_da_re
date56443323_dat_e
dater65332313_dater
dautie72914703dautie
dure56341813du__re
duster74919723duster
eagre64315323_eagre
eater54639843_eater
ecarte84313503ecarte
elate55335883elat_e
elater64724203elater
eluate62315433eluat_e
enate54428153enat_e
equable1849253equable
equated171910403equated
equates162012323equates
equator1637483equator
equators1737473equators
euchre11137663euchre
fare76354463_fa_re
fate75444283_fat_e
feater95224053feater
feature1039853feature
fiacre1137623fiacre
flare84823633fla_re
frater94520593frater
furore9410013furore
future939563future
gate55746573_gat_e
gater64533653_gater
glaire74411303glaire
glare65222963gla_re
goatee73219533goatee
goitre7349003goitre
grate64932883grat_e
grater74625443grater
guar56923293gua_r_
guard74415543gua_rd
guars65021053gua_rs
gumtree1045873gumtree
guttae73210583guttae
gutter73817713gutter
guttle74111973guttle
hare76255733_ha_re
hate78450173_hat_e
hater85034753_hater
hatred104814333_hatred
haute89521613haut_e
heater94828303heater
humate113214443humat_e
hunter94817773hunter
hurter93915853hurter
hurtle93512943hurtle
hustle93113993hustle
irate55627983irat_e
irater65218353irater
jugate14379463jugat_e
juster134617013juster
justle133211583justle
jute115327893ju_t_e
krater104014313krater
late47560483_lat_e
later54843923_later
lathe85626723_lathe
latke94817093_latke
latte55426303_latte
liquate1638423liquat_e
litre55421463_litre
loathe94211383loathe
lucre76415523lu_cre
lunate6316043lunat_e
lure45142463lu__re
luster64023673luster
lustra6358893lustra
lustred8359053lustred
lustres73013233lustres
lute46341013lu_t_e
luxate1338083luxat_e
madre85720173_madre
mare64759333_ma_re
mate65154223_mat_e
mater74438863_mater
matres84522233_matres
matte75626843_matte
mature8313473_mature
maugre9308973maugre
meagre9349323meagre
metre74821303_metre
mitre75522423_mitre
multure939183multure
mure65941333mu__re
murre74821073mu_rre
mustee83922103mustee
muster84724523muster
mutase82811993mutase
mutate83017483mutate
mute65136873mu_t_e
muter74525543mu_ter
mutter84418883mutter
nacre75715363_nacre
nature6311263_nature
neater64424313neater
nitre57519683_nitre
nuance859043nuance
nurture736643nurture
nutate63017373nutate
nutter63918053nutter
oater55433733_oater
orate55133303orat_e
ouster64223733ouster
outage72017533outage
outate62923403outate
outer55633303ou_ter
ovate84214393ovat_e
padre86018163_padre
pare66760843_pa_re
pate65350463_pat_e
pater74740733_pater
piastre9307893piastre
plate74635113plat_e
plater84427693plater
prate75135983prat_e
prater84825353prater
punter84320033punter
pupate104213123pupat_e
pure65543333pu__re
puttee85919723puttee
putter83921443putter
puttie84116303puttie
qat125253333q_at__
qats135331343q_at_s
qua124821973qua___
quack203812503qua_ck
quacked2336793quacked
quacks214710103quacks
quacky24376963quacky
quad144618703qua__d
quadded1934863quadded
quadrat1769273quadrat
quadrate1888053quadrate
quadric1946313quadric
quads154515843qua_ds
quaff201311353qua_ff
quaffed2334253quaffed
quaffer2235133quaffer
quaffs21125693quaffs
quag144815943qua__g
quagga1754143quagga
quaggy2084683quaggy
quagmire2042383quagmire
quags154613253qua_gs
quahog1944103quahog
quai134420393qua__i
quaich2047693quaich
quaigh1935463quaigh
quail144314363qua_il
quailed1737823quailed
quails153412643quails
quaint15415173quaint
quainter1765903quainter
quais144618393qua_is
quaked203910033quaked
quakers20309703quakers
quakes194013343quakes
quakier20239203quakier
quaky214310743qua_ky
qualia1559563qualia
qualm163511183qua_lm
qualms17317243qualms
qualmy20285803qualmy
quango1636493quango
quant143624813qua_nt
quanta153911333quanta
quantal16367893quantal
quanted1738973quanted
quantic18279063quantic
quantile1747323quantile
quantize2645963quantize
quants153614143quants
quantum1845103quantum
quarks193810913quarks
quarrels1735093quarrels
quarried1836103quarried
quarrier1736853quarrier
quarries1749953quarries
quartan1636433quartan
quartered19155973quartered
quarterer18145723quarterer
quartern17286483quartern
quarters173110463quarters
quartets17277583quartets
quartic18258473quartic
quartier1737553quartier
quartile1747053quartile
quartos16328743quartos
quartzes2645463quartzes
quasar1536843quasar
quasars1646903quasars
quash174512163qua_sh
quashed20207983quashed
quasher19198623quasher
quashes192110973quashes
quasi144015023qua_si
quass144413763qua_ss
quasses16209503quasses
quatorzes2743143quatorzes
quatrain1745833quatrain
quavered2144823quavered
quaverer2054593quaverer
quavers19309023quavers
quavery22225483quavery
quay164618353qua__y
quayage2044573quayage
quays174612043qua_ys
qubyte2034243qubyte
queer143712813queer_
queered17117223queered
queerer16106503queerer
queers153510773queers
quern143610403qu_ern
query174212083qu_ery
quester161410023quester
queue143711233qu_eue
queuer15357253queuer
quiche2057903quiche
quieter162810333quieter
quilter16279803quilter
quinate16511573quinat_e
quince173910133quince
quinte153414523quinte
quired163711953qu_ired
quires154015753qu_ires
quirk184011003qu_irk
quirt144624233qu_irt
quirted17369223quirted
quirts154213553quirts
quit136136513quit__
quitch2036413quitch
quitrent1746963quitrent
quits144122353quit_s
quitted17339893quitted
quitter162910753quitter
quiver18278743quiver
quota145111963quot_a
quotas15339433quotas
quoted16359453quoted
quoters16369273quoters
quotes153312463quotes
quoth173310353quot_h
quotha18365113quotha
rare45348433_ra_re
rate45458763_rat_e
rater54943283_rater
rathe85821923_rathe
rugate75813813rugat_e
rupture966163rupture
rustle63615413rustle
sabre74821503_sabre
sate45556103_sat_e
satire63218003_satire
saute55028083saut_e
scare75334463sca_re
scathe114414993scathe
seater64534163seater
share86437083sha_re
skate94721553skat_e
skater105015493skater
slate55438283slat_e
slater64429183slater
snare54429983sna_re
snathe94415113snathe
spare75135563spa_re
spate74731583spat_e
spathe115115693spathe
squamae1845723squamae
squared173610563squa_red
squarer163410663squa_rer
squares163714463squa_res
squark19438113squa_rk
squat143720143squat__
squatly1946433squatly
squats153712963squat_s
squatted1835343squatted
squatter1735913squatter
squatty1964823squatty
squire155912463squ_ire
stare54440263sta_re
state56237333stat_e
stater64427563stater
statue66015323statue
stature74410683stature
suable83920553suable
suave83519873sua_ve
suaver93014233suaver
subtle82113433subtle
sucre75019103su_cre
suite54829563suit_e
suiter64121813suiter
sultry938463sultry
sure45447413su__re
sutra54217933su_tra
suttee63721543suttee
suture6313203suture
sware85828213swa_re
swathe125514113swathe
tare45957623_ta_re
tarre55825633_tarre
tate44748603_tat_e
tater54138613_tater
tauter64318023tauter
theatre10358503theatre
titre54619393_titre
tuatara745513tuatara
tuatera756383tuatera
tubate82813173tubat_e
tufter9319933tufter
turtle63213573turtle
tutee5423523tu_tee
tuyere9408613tuyere
ultra539363_ultra
untie54425493_untie
untrue6310773_untrue
uptore8279453_uptore
urare56322553_urare
urate55432163urat_e
ute35335883_u_t_e
utter54218763_utter
vulture1036763vulture
ware76254723_wa_re
water84733323_water
yare75636943_ya_re
zaire14311993_zaire

Search took 6 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 Filter1786911127160.420425454.8
2DLD Change Limit1127164195.39020912.1
3Display Results4194190.1432930.1
 (SQL Overall)1786914195.95330017.0
 
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.