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

361 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
shairds1121626(None) 
shaird10288701shaird_
shairns10276781shairns
shards104319171sha_rds
cairds96411512_cairds
chairs114916182chair_s
chards125119732cha_rds
hairdo1036432_hairdo
hairdos1136822_hairdos
hairs86225172_hair_s
hards96435652_ha_rds
lairds74711612_lairds
saids65328852s_ai_ds
sards64736182s_a_rds
seabirds1164402seabirds
shads95124482sha__ds
shairn9269062shair_n
shard96125962sha_rd_
shares95236412sha_res
sharias102516002sharias
sharifs13279902sharifs
sharks135019722sha_rks
sharns95516982sha_rns
sharps115516082sha_rps
sherds105614722sh_erds
shires95225572sh_ires
shirks134814122sh_irks
shirrs94413172sh_irrs
shirts94918342sh_irts
sparids103512122sparids
stairs65416332stair_s
swards105415132swa_rds
thairms1244452thairms
thirds10438602th_irds
yairds10448022_yairds
acarids105312243acarids
aids57846363__ai_ds
airns55521033__airns
airs46447423__air_s
airts55626343__airts
ascarids11438503ascarids
awards107113453awa_rds
bairns86710873_bairns
bards87139643_ba_rds
beards94116673bea_rds
begirds1134883begirds
birds85421333__birds
boards94616933boa_rds
braids95015693brai_ds
briards10398553briards
caids85226423_cai_ds
caird85717233_caird_
cairns85313303_cairns
cards85137933_ca_rds
chads116122233cha__ds
chaines124518733chaines
chains114819703chai_ns
chair105519633chair__
chaired134211243chaired
chais107530313chai__s
chaises124317493chaises
chakras16428503chakras
charas114223613cha_ras
chard116124743cha_rd_
chares115631803cha_res
charks155219703cha_rks
charms135218843cha_rms
charros124312143charros
charrs115219193cha_rrs
chars105936643cha_r_s
charts115823093cha_rts
chirks155414843ch_irks
chirms135113983ch_irms
chiros114617773ch_iros
chirps135414003ch_irps
chirrs114514983ch_irrs
chirus114615693ch_irus
choirs114911883choir_s
chords125214633ch_ords
deairs74013783deair_s
echards1337963echa_rds
engirds995053engirds
fairs85825443_fair_s
fards96629843_fa_rds
flairs95711913flair_s
gharris11306433gharris
girds74816993__girds
glaires84010143glaires
glairs75211333glair_s
guards84611573gua_rds
haars85620473_haar_s
haeres94017033_haeres
haiks125120933_hai_ks
haikus13538293_haikus
hails85231643_hai_ls
haints94417583_haints
hair76330143_hair__
haired105117173_haired
hairy115316833_hair_y
halids104016133_halids
hands95327383_ha_nds
hard85443503_ha_rd_
hardy125622063_ha_rdy
hares86255543_ha_res
harks126333433_ha_rks
harls85634503_ha_rls
harms106829013_ha_rms
harps105926873_ha_rps
harts88441593_ha_rts
hatreds11307813_hatreds
hazards2037463_hazards
heirs85618563_heir_s
herds96424683_h_erds
hinds96721473_h_inds
hires86134343_h_ires
hoards104912623_hoards
hurds95219073_h_urds
laird65417793_laird_
lairs55425873_lair_s
lards65331863_la_rds
liards75212613lia_rds
maids86327143_mai_ds
mairs76228303_mair_s
mohairs1234953mohair_s
naiads739013_naiads
nairas6312783_nairas
nairus639143_nairus
nards65928463_na_rds
pairs75325833_pair_s
pards85634333_pa_rds
pharos11312063pha_ros
plaids94312443plai_ds
qaids156116313_qai_ds
raids65827513_rai_ds
sabirs85414633sabir_s
sabras85116363s_abras
sabres85520863s_abres
sahibs1137083sahi_bs
saices84221803s_aices
said55742113s_ai_d_
saigas74114293s_aigas
sails55738103s_ai_ls
sains55639973s_ai_ns
saints65122423s_aints
saiyids11174893s_aiyids
salads75316963s_alads
sands65228583s_a_nds
sard55344243s_a_rd_
sarins63932623s_arins
saris54544953s_a_ris
sarks96632463s_a_rks
sarods74918573s_arods
saros55238063s_a_ros
satires72617573satires
sayeds10469253s_ayeds
sayids104310973s_ayids
scads85419963sca__ds
scalds94813693sca_lds
scares85033003sca_res
scarfs114714683sca_rfs
scarps104718603sca_rps
scars75433533sca_r_s
scarts85321493sca_rts
scaurs85512053scaur_s
seabeds10417223seabeds
seabird1055363seabird_
sears54744913sea_r_s
seawards1237203seawards
shackos16429023shackos
shacks154817563sha_cks
shad86230913sha__d_
shade95125583sha__de
shaded114518873shaded_
shaders115915553shaders
shades105924533sha_des
shadings13327433shadings
shadows1437193shadows
shadufs1433673shadufs
shady125416513sha__dy
shafts125411443sha_fts
shags95123863sha__gs
shahs115919513sha__hs
shaitan1036893shaitan
shaitans1136413shaitans
shakers144015563shakers
shakes135024593sha_kes
shakoes144510023shakoes
shakos134912193sha_kos
shaled105023953shaled_
shales94731253sha_les
shaloms1288983shaloms
shamans123610903shamans
shamas113717943sha_mas
shamed125120213shamed_
shames114726223sha_mes
shammas14358723shammas
shammes144312833shammes
shammos14307203shammos
shamois123210423shamois
shamos114216983sha_mos
shamoys15367283shamoys
shams105829413sha__ms
shamus114112813sha_mus
shandy134710033sha_ndy
shanks135315583sha_nks
shantis103313103shantis
shaped125020103shaped_
shapers124016893shapers
shapes115124953sha_pes
share86437083sha_r_e
shared105829063sha_red
sharer95025483sha_rer
sharers104720623sharers
sharia93116733sha_ria
shariah132210533shariah
shariahs14206393shariahs
sharif122917123sha_rif
sharing113723243sharing
shark126225023sha_r_k
sharn84823703sha_r_n
sharny124711833sha_rny
sharp104922533sha_r_p
sharpy145211033sha_rpy
shaughs14245283shaughs
shauls94913113sha_uls
shaved135118383shaved_
shavers134115093shavers
shaves125224933sha_ves
shavies134213213shavies
shavings15356333shavings
shawed134817233shawed_
shawls125411973sha_wls
shawms14579563sha_wms
shaws116226263sha__ws
shays116021433sha__ys
shears93820903shear_s
sheds96122703sh__eds
sheers94322403sheer_s
sheikhs17233993sheikhs
sheiks132510013shei_ks
sheilas1059403sheilas
shends105313773sh_ends
sherd96321153sh_erd_
sherifs13299683sherifs
sherris10168803sherris
shied96125493sh_ied_
shields11538043shields
shiels95418923sh_iels
shiers94921753sh_iers
shies86136553sh_i_es
shifts124412943sh_ifts
shills94519613sh_ills
shims104422553sh_i_ms
shindy13449323sh_indy
shindys14314133sh_indys
shines95028913sh_ines
shins85131043sh_i_ns
ships105123773sh_i_ps
shire84727133sh_ir_e
shirk124817843sh_ir_k
shirr84716923sh_ir_r
shirt84533903sh_ir_t
shirty124312563sh_irty
shists96515113sh_ists
shits84731173sh_i_ts
shivas124512413sh_ivas
shives124921413sh_ives
shivs115018803sh_i_vs
shoers94518333shoer_s
shores94830413sh_ores
shorls94516203sh_orls
shorts95321743sh_orts
shreds105613053sh_reds
shrieks14377673shrieks
shrifts1335963shrifts
shrikes144412393shrikes
shrills10389933shrills
shrimps14516753shrimps
shrines104618693shrines
shrinks14397913shrinks
shris84221453sh__ris
shrives134416173shrives
shrouds1136023shrouds
shticks16356963shticks
shtiks13297833shti_ks
shyers124712203shyer_s
sialids839723sialids
silds65520523s__ilds
sires55945373s__ires
sirs44338333s__ir_s
skalds11437833ska_lds
skids104615333s_ki_ds
skirls10449823s_kirls
skirrs10448193s_kirrs
skirts104111503s_kirts
sloids73712693sloi_ds
smarms105712533sma_rms
smarts86218003sma_rts
smirks124910123s_mirks
snails64816653snai_ls
snares65329033sna_res
snarfs95113423sna_rfs
snarks104815733sna_rks
snarls64016873sna_rls
soars54732513soa_r_s
solids74116403soli_ds
sords64527803s__ords
spails84817823spai_ls
spaits85017473spai_ts
spares84834553spa_res
sparid94016933sparid_
sparks124616363spa_rks
spars75431543spa_r_s
speirs85013233speir_s
spires84628113s_pires
spirts85317133s_pirts
squids16409803squi_ds
squires163812843squires
squirms18376343squirms
squirts16348013squirts
staid66722083stai_d_
staigs75414813stai_gs
stains64923653stai_ns
stair54719943stair__
stands75118053sta_nds
stares66038753sta_res
stars55836573sta_r_s
starts65423123sta_rts
stirks104914243s_tirks
stirps85011823s_tirps
stirs55921623s_tir_s
sunbirds1143903sunbirds
surds65624663s__urds
swails94913123swai_ls
swains94513953swai_ns
sward94221463swa_rd_
swarfs125612063swa_rfs
swarms116112173swa_rms
swirls94010133s_wirls
swords104510803s_words
thairm1156963thair_m
tharms115712243tha_rms
theirs94610353their_s
third95912493th_ird_
thirls95012063th_irls
ungirds9105303ungirds
unhairs1036373unhair_s
upgirds11103073upgirds
vairs85019133_vair_s
wairs86424063_wair_s
wards97734403_wa_rds
weirds10478053_weirds
wharfs1546373wha_rfs
whids125413983wh_i_ds
whirls124710533wh_irls
whirrs12408593wh_irrs
whirs115218093wh_ir_s
yaird96111913_yaird_
yards95324613_ya_rds
yirds96612513__yirds
zaires1539703_zaires

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.453394461.4
2DLD Change Limit1340273616.76319817.7
3Display Results3613610.1262865.1
 (SQL Overall)1786913617.34224338.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.