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

217 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
ardours836888(None) 
arbours93910041arbours
ardors74416871ardo_rs
ardour74110901ardour_
armours9389851armours
amours83512662a_mours
arbors84717882arbo_rs
arbour84211332arbour_
ardor64617862ardo_r_
arduous837612arduous
armors85017812armo_rs
armour84411852armour_
armoury12376232armoury
candours11408642candours
harbours1346922harbours
odours7418252_odours
pandours11317992pandours
parlours1036152parlours
abhors11410623abho_rs
actors81016763acto_rs
adders84315703a_dders
adjourn1563433adjourn
adjourns1662863adjourns
adjure1435843a_djure
adjures1536233a_djures
adnouns835453adnouns
adobes94411533a_dobes
adobos9438453a_dobos
adonis7314063a_donis
adopts998083a_dopts
adore65723673a_do_re
adorers84411733a_dorers
adores74420723a_dores
adorn64917093a_do_rn
adorns74212613a_dorns
ados57633513a_do__s
aiders74524633aid_ers
alders74218423ald_ers
aldols7109713aldo_ls
aldoses8311203aldoses
algors7312553algo_rs
amadous1038503amadou_s
amour75014853a_mour_
apodous1037403apodou_s
arbor74818113arbo_r_
arbores94016033arbores
arboured1156253arboured
archers124414573archers
arcus76918863ar_cu_s
ardebs937013ard_ebs
arenous7314183arenou_s
areolas71013863areolas
areoles71016953areoles
argols74514613argo_ls
argons75018203argo_ns
argots74116033argo_ts
arguers8489033arguers
argues74516413ar_gues
argus66716543ar_gu_s
ariosos7409853ariosos
arkoses113910833arkoses
armers85520273ar_mers
armfuls1275013armfuls
armoire938133armoire
armoires1057623armoires
armor75118053armo_r_
armorers10288973armorers
armory114211473armo_ry
armoured1165223armoured
armourer1054883armourer
armourers1154063armourers
armouries1146243armouries
armure8710133ar_mure
armures9510273ar_mures
aroids75118223ar_oids
aromas81018613ar_omas
around72712413ar_ound
arouse65019983ar_ouse
arousers84810983ar_ousers
arouses74921293ar_ouses
arrears738843arrears
arrobas969213arrobas
arrows92813483arro_ws
arroyos1036533arroyos
arsons63917213arso_ns
arums75517833ar__ums
arvos86015663arvo__s
augurs7399963a_ugurs
aurous64119263aurou_s
auteurs7137503auteurs
awmous1157713awmou_s
candors104216763cando_rs
candour104210243candour_
carders104820353card_ers
cardons104519933cardo_ns
cardoons113411943cardoons
carious93320283cariou_s
clours85215093_clours
colours95913443colours
croups104312553cr_oups
cruors838633cruo_rs
detours858043detours
devours1166643devours
doers65225713__doers
dolours8438823dolours
doors65022133__doors
dorrs65520593__dorrs
dors56747603__do_rs
doums85417643__doums
dour56330433__dour_
doura66518663__doura
douras75016723__douras
drouks1137123dr_ouks
dyvours1453183dyvours
eardrums11524483eardrums
errors63311313erro_rs
faitours1134263faitours
farceurs13464723farceurs
favours13437093favours
fervours1453053fervours
flours94414053_flours
fours85521493__fours
giaours834573giaours
groups94210513gr_oups
grouts75015613gr_outs
handouts1238233handouts
harbors12412413harbo_rs
harbour1247053harbour_
hardcourt1544043hardcourt
haviours1443843haviours
honours10339373honours
hours85422393__hours
humours1286433humours
indoors838553indoors
inpours936423inpours
iodous7311503iodou_s
labours9349893labours
larders83516943lard_ers
lardons83914493lardo_ns
lardoons9398483lardoons
lours55125293__lours
nodous7711333nodou_s
odors64514283_odo_rs
odour64710493_odour_
orders74315993ord_ers
ordos65216203ordo__s
ordure756813ord_ure
ordures856473ord_ures
ours47237563___ours
padouks1434873padouks
pandoors11258983pandoors
pandour10408213pandour_
paradors113411903parado_rs
paramours1345653paramours
pardners11269193pardners
pardoners12208213pardoners
pardons103817623pardo_ns
parlors9312913parlo_rs
parlour937263parlour_
parlous9414293parlou_s
parous84024163par_ou_s
paviours1343613paviours
pours74623183__pours
priors83914483prio_rs
radars71314673rad_ars
radiums10299313radiums
radius73914873radiu_s
radomes10311053radomes
radons74118533rado_ns
ragouts838543ragouts
ramous8417113ramou_s
rancours1076713rancours
razors154711663razo_rs
recurs83315803_recurs
redouts81411663redouts
repours9310233repours
rigours8207003rigours
roars55622243_r_oars
roues56039353_r_oues
roups75118903_r_oups
routs57133413_r_outs
rumours976373rumours
sandburs11105623sandburs
santours837183santours
sapours93610623sapours
sarcous9312933sarcou_s
sardars83112903sard_ars
sardius839553sardiu_s
sartors7314963sarto_rs
saviours1154273saviours
savours10389343savours
scours84913593_scours
siddurs934173siddurs
sordors8310003sordo_rs
sours55230503__sours
stours65015633_stours
sudors7311103sudo_rs
tabours94110093tabours
tambours1255873tambours
tandoors9258053tandoors
tenours72610073tenours
tours55325893__tours
trouts66116633tr_outs
tryouts1035313tryouts
tumours976753tumours
undoers82910583undoers
valours10248743valours
vapours12277463vapours
various103113103variou_s
velours10278083velours
vigours11285483vigours
vodouns1134763vodouns
vodous1038603vodou_s
vrouws12494743vr_ouws
warders113416813ward_ers
yarders113211593yard_ers
yours85217883__yours

Search took 9 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.1561145455.1
2DLD Change Limit1340272178.11016526.1
3Display Results2172170.1561391.0
 (SQL Overall)1786912178.42221217.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.