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

288 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
hairdo103643(None) 
hairdos1136821hairdos
caird85717232caird_
cairds96411512cairds
hair76330142hair__
haired105117172haired
hairs86225172hair_s
hairy115316832hair_y
hard85443502ha_rd_
hards96435652ha_rds
hardy125622062ha_rdy
heirdom1344492heirdom
laird65417792laird_
lairds74711612lairds
shaird10288702shaird_
shairds11216262shairds
tardo65321102ta_rdo
weirdo10405882weirdo
yaird96111912yaird_
yairds10448022yairds
ado49146873_a__do
aero45435343_aer_o
aid49269073_ai_d_
aide56044993_ai_de
aids57846353_ai_ds
aikido1135473_aikido
air38058393_air__
airdrop1044423_airdrop
aired66032923_aired
airer54927893_airer
airn46433833_air_n
airns55521033_airns
airs46447423_air_s
airt45757783_air_t
airth85621023_airth
airts55626343_airts
airy75734153_air_y
amido85720983_amido
andro6314163_andro
arco68331543_a_rco
ardor64617863_a_rdor
arid57642713_arid_
arvo76023433_a_rvo
azido155411543_azido
bairn77515533bair_n
bairns86710873bairns
bard75648863ba_rd_
barde85330773ba_rde
bards87139643ba_rds
barrio8312573barrio
bird76128323_bird_
birds85421333_birds
biro66131213_bir_o
cabildo1254723cabildo
caid77837533cai_d_
caids85226423cai_ds
cairn75717513cair_n
cairns85313303cairns
cairny11557823cairny
carbo94923843ca_rbo
card710245873ca_rd_
cardio9915673ca_rdio
cardon94120853ca_rdon
cards85137933ca_rds
cargo85322073ca_rgo
chair105519633chair__
chaired134211243chaired
chairs114916183chair_s
chard116124743cha_rd_
chards125119733cha_rds
charro114212953cha_rro
chiro105320343chir_o
dado67126333da__do
daimio937463daimio
daimyo1233193daimyo
dairy97016303dair_y
dido66528193_di_do
dildo71911773_dildo
fado87226463fa__do
fair76332523fair__
faired105915773faired
fairer95212063fairer
fairly125610013fairly
fairs85825443fair_s
fairy115318283fair_y
fard85639063fa_rd_
fards96629843fa_rds
faro76136923fa_r_o
fido87726393_fi_do
fordo97218653_fordo
garda7316763ga_rda
gird65424993_gird_
girds74816993_girds
giro55828633_gir_o
guiro63712093guir_o
haar77323493haar__
haars85620473haar_s
had77658763ha__d_
hade85440193ha__de
haded105227623haded_
hadj155818673ha__dj
hadron102913753hadron
haed86338583ha_ed_
haeres94017033haeres
hagdon1188283ha_gdon
hagride1237553hagride
hagrode1236443hagrode
haik115526983hai__k
haika125313793hai_ka
haiks125120933hai_ks
haiku126113693hai_ku
haikus13538293haikus
hail74839063hai__l
hailed104122743hailed
hailer94720343hailer
hails85231643hai_ls
haint85436323hai_nt
haints94417583haints
haircap14134753haircap
haircut1246833haircut
hairier103111053hairier
hairlock1754023hairlock
hairnet10911703hairnet
hairpin1245413hairpin
hairwork1845073hairwork
hairworm1644533hairworm
haled95335823haled_
halid94424983halid_
halide103417993halide
halidom1386443halidom
halids104016133halids
hallo85127553ha_llo
halloo95118973halloo
halo76437323ha__lo
hamada1239923hamada
hand86833713ha_nd_
hands95327383ha_nds
handy125520873ha_ndy
hangdog1343133hangdog
hao67251123ha___o
hapkido1743143hapkido
harbor11410723ha_rbor
harden105718533ha_rden
harder105022403ha_rder
hardly135112833ha_rdly
hardtop1345053ha_rdtop
hare76255733ha_r_e
hared95742183ha_red
harem104924453ha_rem
hares86255543ha_res
haricot12311963haricot
haring104233003haring
hark115237393ha_r_k
harks126333433ha_rks
harl75740003ha_r_l
harlot94422803ha_rlot
harls85634503ha_rls
harm95637793ha_r_m
harms106829013ha_rms
harp96134293ha_r_p
harps105926873ha_rps
harpy136418213ha_rpy
harrow122610773harrow
harry115322953ha_rry
harsh116418053ha_rsh
hart76865773ha_r_t
harts88441593ha_rts
hated95734023hated_
hatred104814333hatred
hatreds11307813hatreds
hawed126025423hawed_
hayed125822013hayed_
hayride1437323hayride
hazard1938403hazard_
hazards2037463hazards
hazed185222203hazed_
heard95222753heard_
heir77523803heir__
heirdoms1444353heirdoms
heired103813043heired
heirs85618563heir_s
herd84933063h_erd_
herds96424683h_erds
hero74635783h_er_o
hid76248373h_i_d_
hide85134633h_i_de
hied85434043h_ied_
hillo84721653h_illo
hind85529753h_ind_
hinds96721473h_inds
hippo12369063h_ippo
hire75538963h_ir_e
hired95226263h_ired
hiree85427803h_iree
hirer85423123h_irer
hires86134343h_ires
hoard94918313hoard_
hoards104912623hoards
horde94623053h_orde
hotrod1048803hotrod
hurds95219073h_urds
hydro12259423hydr_o
imido85812243imi_do
karoo92519583ka_roo
karroo10410013karroo
kiddo11398943_kiddo
laid56439143lai_d_
lair45934153lair__
lairdly1134913lairdly
laired75216813laired
lairs55425873lair_s
lard56742003la_rd_
lardon74415063la_rdon
lards65331863la_rds
lardy96119273la_rdy
largo65319783la_rgo
liard65418593liard_
liards75212613liards
lido56028153_li_do
macro94718173macr_o
maid75537663mai_d_
maids86327143mai_ds
mair66133783mair__
mairs76228303mair_s
misdo85413183_misdo
naiad6313403naiad_
naiads739013naiads
naira5314743nair_a
nairas6312783nairas
nairu5413813nair_u
nairus639143nairus
narco76718243na_rco
nard56634453na_rd_
nards65928463na_rds
ordo54622353__ordo
overdo10128363overdo
paid75737483pai_d_
pair66031513pair__
paired95017523paired
pairs75325833pair_s
pard76441323pa_rd_
pardi85723953pa_rdi
pardon94618733pa_rdon
pards85634333pa_rds
pardy115523953pa_rdy
pareo74632603pa_reo
pargo86723723pa_rgo
parvo107719183pa_rvo
qaid146023843qai_d_
qaids156116313qai_ds
raid55243073rai_d_
raids65827513rai_ds
ramrod936833ramrod
said55742113sai_d_
saids65328853sai_ds
sard55344243sa_rd_
sards64736183sa_rds
sargo65424413sa_rgo
sarod65325873sa_rod
shairn9269063shair_n
shairns10276783shairns
shard96125963sha_rd_
shards104319173sha_rds
tardy94720463ta_rdy
taro46846913ta_r_o
thairm1156963thair_m
thairms1244453thairms
third95912493third_
thirds10438603thirds
tiro46832363_tir_o
vair75624143vair__
vairs85019133vair_s
vireo84816453_vireo
wair75830053wair__
waired106015833waired
wairs86424063wair_s
ward86542253wa_rd_
wards97734403wa_rds
weird95111283weird_
weirdos11355123weirdos
weirds10478053weirds
weirdy13395463weirdy
yard85633253ya_rd_
yards95324613ya_rds
yird87018983_yird_
yirds96612513_yirds
zaire14311993zair_e
zaires1539703zaires

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 Filter1786911127160.266671770.7
2DLD Change Limit1127162886.18618221.1
3Display Results2882880.0763789.5
 (SQL Overall)1786912886.52827373.0
 
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.