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

218 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
hairdos113682(None) 
hairdo1036431hairdo_
cairds96411512caird_s
hairs86225172hair__s
hards96435652ha_rd_s
heirdom1344492heirdom
heirdoms1444352heirdoms
lairds74711612laird_s
shairds11216262shaird_s
weirdos11355122weirdos
yairds10448022yaird_s
ados57633513_a__dos
aides65336603_ai_des
aids57846363_ai_d_s
aikidos1253883_aikidos
airbus848343_airbus
airdrop1044423_airdrop
airdrops1144343_airdrops
airers64922313_airers
airns55521033_air_ns
airpost939243_airpost
airs46447423_air__s
airths95414253_airths
airts55626343_air_ts
andros7313303_andros
ardor64617863_a_rdor
ardors74416873_a_rdors
arvos86015663_a_rvos
bairns86710873bair_ns
bardes95026933ba_rdes
bards87139643ba_rd_s
barrios9310773barrios
birds85421333_bird_s
biros75325133_bir_os
cabildos1363803cabildos
caids85226423cai_d_s
caird85717233caird__
cairns85313303cair_ns
carbos105122263ca_rbos
cardon94120853ca_rdon
cardons104519933ca_rdons
cards85137933ca_rd_s
cargos94619183ca_rgos
chairs114916183chair__s
chards125119733cha_rd_s
charros124312143cha_rros
chiros114617773chir_os
dados75522433da__dos
daimios1035753daimios
daimyos1342813daimyos
dairies84217733dairies
didos76820813_di_dos
dildos8179303_dildos
eidos65817753_ei_dos
fados95620733fa__dos
fairies103516043fairies
fairs85825443fair__s
fards96629843fa_rd_s
faros85532023fa_r_os
fidos95819053_fi_dos
girds74816993_gird_s
giros65722653_gir_os
guiros7389093guir_os
haars85620473haar__s
hades96035113ha__des
hadron102913753hadr_on
hadrons113314303hadrons
haeredes1246333haeredes
haeres94017033haer_es
hagdon1188283ha_gdon
hagdons1258523ha_gdons
hagrides1337623hagrides
hagrode1236443hagrode
haiks125120933hai__ks
haikus13538293hai_kus
hailers104017263hailers
hails85231643hai__ls
haints94417583hai_nts
hair76330143hair___
haircap14134753haircap
haircaps15144363haircaps
haircut1246833haircut
haircuts1343663haircuts
haired105117173hair_ed
hairier103111053hairier
hairiest11612463hairiest
hairless1157413hairless
hairlock1754023hairlock
hairlocks1863773hairlocks
hairnet10911703hairnet
hairnets1195633hairnets
hairpin1245413hairpin
hairpins1365433hairpins
hairwork1845073hairwork
hairworks1944843hairworks
hairworm1644543hairworm
hairworms1743973hairworms
hairy115316833hair__y
halides113416663halides
halidom1386443halidom
halidoms1485823halidoms
halids104016133halid_s
halloos103716743halloos
hallos95425103ha_llos
halos85230253ha__los
hamadas1339673hamadas
hands95327383ha_nd_s
hangdog1343133hangdog
hangdogs1443603hangdogs
hapkidos1842713hapkidos
harass9313943ha_rass
harbor11410723ha_rbor
harbors12412413ha_rbors
hard85443503ha_rd__
hardass1139753ha_rdass
harden105718533ha_rden
hardens113815023ha_rdens
harder105022403ha_rder
hardest113118413ha_rdest
hardies114923233ha_rdies
hardly135112833ha_rdly
hardnose1245723ha_rdnose
hardtop1345053ha_rdtop
hardtops1444843ha_rdtops
hardy125622063ha_rd_y
harems115513823ha_rems
hares86255543ha_r_es
haricot12311963haricot
haricots1347333haricots
harks126333433ha_r_ks
harlot94422803ha_rlot
harlots103413293ha_rlots
harls85634503ha_r_ls
harms106829013ha_r_ms
harps105926873ha_r_ps
harries103525493harries
harrow122610773ha_rrow
harrows132611033harrows
harts88441593ha_r_ts
hatreds11307813hatreds
hayrides1536883hayrides
hazardous2243103hazardous
hazards2037463hazard_s
heiress1036813heiress
heirs85618563heir__s
herds96424683h_erd_s
heros84930863h_er_os
hides95129423h_i_des
hillos94618893h_illos
hinds96721473h_ind_s
hippos13408433h_ippos
hirees95117293h_irees
hirers94518063h_irers
hires86134343h_ir_es
hoards104912623hoard_s
hordes104921633h_ordes
hotrods1148283hotrods
hurds95219073h_urd_s
hydros13279363hydr_os
karoos102415803ka_roos
karroos1139313karroos
kiddos12416863_kiddos
laird65417793laird__
lairdly1134913lairdly
lairs55425873lair__s
lardon74415063la_rdon
lardons83914493la_rdons
lards65331863la_rd_s
largos74815063la_rgos
liards75212613liard_s
lidos65219883_li_dos
macros104017013macr_os
maids86327143mai_d_s
mairs76228303mair__s
naiades838213naiades
naiads739013naiad_s
nairas6312783nair_as
nairus639143nair_us
narcos86714203na_rcos
nards65928463na_rd_s
ordos65216203__ordos
pairs75325833pair__s
parados103816053parados
pardon94618733pa_rdon
pardons103817623pa_rdons
pards85634333pa_rd_s
pareos87023773pa_reos
pargos95719043pa_rgos
parodos103011753parodos
parvos116614753pa_rvos
pharos11312063pha_r_os
qaids156116313qai_d_s
raids65827513rai_d_s
ramrods1036583ramrods
saids65328853sai_d_s
sards64736183sa_rd_s
sargos74318273sa_rgos
sarods74918573sa_rods
saros55238063sa_r_os
shaird10288703shaird__
shairns10276783shair_ns
shards104319173sha_rd_s
tardo65321103ta_rdo_
taros55640823ta_r_os
thairms1244453thair_ms
thirds10438603third_s
tiros54524893_tir_os
vairs85019133vair__s
vireos94212453_vireos
wairs86424063wair__s
wards97734403wa_rd_s
weirdo10405883weirdo_
weirdoes12323833weirdoes
weirds10478053weird_s
yaird96111913yaird__
yards95324613ya_rd_s
yirds96612513_yird_s
zaires1539703zair_es

Search took 7 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.436409841.7
2DLD Change Limit1340272186.25021444.3
3Display Results2182180.0802725.0
 (SQL Overall)1786912186.76626410.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.