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

416 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
shairns1027678(None) 
shairds11216261shairds
shairn9269061shairn_
sharns95516981sha_rns
airns55521032__airns
bairns86710872_bairns
cairns85313302_cairns
chains114819702chai_ns
chairs114916182chair_s
hairs86225172_hair_s
sains55639972s_ai_ns
sarins63932622s_arins
shaird10288702shair_d
shaitans1136412shaitans
shamans123610902shamans
shards104319172sha_rds
shares95236412sha_res
sharias102516002sharias
sharifs13279902sharifs
sharing113723242sharing
sharks135019722sha_rks
sharn84823702sha_rn_
sharny124711832sha_rny
sharps115516082sha_rps
shins85131042sh_i_ns
shires95225572sh_ires
shirks134814122sh_irks
shirrs94413172sh_irrs
shirts94918342sh_irts
stains64923652stai_ns
stairs65416332stair_s
swains94513952swai_ns
thairms1244452thairms
ains46158883__ai_ns
airn46433833__airn_
airs46447423__air_s
airts55626343__airts
bairn77515533_bairn_
barns76335143_ba_rns
blains84516373blai_ns
brains85125473brai_ns
cains75334303_cai_ns
cairds96411513_cairds
cairn75717513_cairn_
cairny11557823_cairny
carns75937563_ca_rns
chagrins1437073chagrins
chain105723673chai_n_
chaine115119223chai_ne
chaines124518733chaines
chair105519633chair__
chaired134211243chaired
chairing143110773chairing
chairmans1685143chairmans
chais107530313chai__s
chaises124317493chaises
chakras16428503chakras
charas114223613cha_ras
chards125119733cha_rds
chares115631803cha_res
charing133721323charing
charks155219703cha_rks
charms135218843cha_rms
charros124312143charros
charrs115219193cha_rrs
chars105936643cha_r_s
charts115823093cha_rts
chazans21268123chazans
chins105631463ch_i_ns
chirks155414843ch_irks
chirms135113983ch_irms
chiros114617773ch_iros
chirps135414003ch_irps
chirrs114514983ch_irrs
chirus114615693ch_irus
choirs114911883choir_s
churns114910233ch_urns
darns66927893_da_rns
deairs74013783deair_s
dharna1055263dha_rna
dharnas1155373dha_rnas
drains73719403drai_ns
earns55927563_ea_rns
elains64919853elai_ns
fairs85825443_fair_s
firns86018543__firns
flairs95711913flair_s
gains65729513_gai_ns
gharris11306433gharris
girns64516803__girns
glaires84010143glaires
glairs75211333glair_s
grains74223093grai_ns
haars85620473_haar_s
hadrons113314303_hadrons
haeres94017033_haeres
haiks125120933_hai_ks
haikus13538293_haikus
hails85231643_hai_ls
haint85436323_hai_nt
haints94417583_haints
hair76330143_hair__
hairdo1036433_hairdo
hairdos1136823_hairdos
haired105117173_haired
hairnet10911703_hairnet
hairnets1195633_hairnets
hairpins1365433_hairpins
hairy115316833_hair_y
halons95720713_halons
hards96435653_ha_rds
hares86255543_ha_res
haring104233003_haring
harks126333433_ha_rks
harls85634503_ha_rls
harms106829013_ha_rms
harps105926873_ha_rps
harts88441593_ha_rts
havens124514043_havens
hazans183411653_hazans
heirs85618563_heir_s
herns84825583_h_erns
hins76447993_h_i_ns
hires86134343_h_ires
horns86125333_h_orns
kains96125643_kai_ns
karns96624143_ka_rns
khans124615173kha__ns
khazens2332663khazens
kirns95315453__kirns
lairds74711613_lairds
lairs55425873_lair_s
learns65513743lea_rns
mains75635113_mai_ns
mairs76228303_mair_s
mohairs1234953mohair_s
nairas6312783_nairas
nairus639143_nairus
pains75138283_pai_ns
pairs75325833_pair_s
pharos11312063pha_ros
pirns76020093__pirns
plains85019593plai_ns
rains55140233_rai_ns
sabins85521983s_abins
sabirs85414633sabir_s
sabras85116363s_abras
sabres85520863s_abres
sadirons936023sadirons
sahibs1137083sahi_bs
saices84221803s_aices
saids65328853s_ai_ds
saigas74114293s_aigas
sails55738103s_ai_ls
saimins9312113s_aimins
sain45551293s_ai_n_
saint55147073s_ai_nt
saints65122423s_aints
salons63823693s_alons
sans45153363s_a__ns
sapiens9310173sapiens
sarans64224433s_arans
sards64736183s_a_rds
sarin55239253s_arin_
saris54544953s_a_ris
sarks96632463s_a_rks
saros55238063s_a_ros
sasins64923103s_asins
satins64930483s_atins
satires72617573satires
savarins1139893savarins
savins93923133s_avins
scans74625103sca__ns
scares85033003sca_res
scarfs114714683sca_rfs
scaring103421973scaring
scarps104718603sca_rps
scars75433533sca_r_s
scarts85321493sca_rts
scaurs85512053scaur_s
scions82612243s_cions
scorns85713023s_corns
seabirds1164403seabirds
searing83330923searing
sears54744913sea_r_s
seasons72614233seasons
seawans10379943seawans
secerns987733secerns
serins64029673seri_ns
shackos16429023shackos
shacks154817563sha_cks
shaders115915553shaders
shades105924533sha_des
shading123115563shading
shadings13327433shadings
shadows1437193shadows
shads95124483sha__ds
shadufs1433673shadufs
shafts125411443sha_fts
shagreens1342633shagreens
shags95123863sha__gs
shahs115919513sha__hs
shaitan1036893shaitan
shaken134113613shaken_
shakers144015563shakers
shakes135024593sha_kes
shaking153317253shaking
shakoes144510023shakoes
shakos134912193sha_kos
shales94731253sha_les
shaloms1288983shaloms
shaman113314283shaman_
shamas113717943sha_mas
shames114726223sha_mes
shaming133016743shaming
shamisens1442603shamisens
shammas14358723shammas
shammes144312833shammes
shammos14307203shammos
shamois123210423shamois
shamos114216983sha_mos
shamoys15367283shamoys
shams105829413sha__ms
shamus114112813sha_mus
shank125422193sha__nk
shanks135315583sha_nks
shanny124110093sha_nny
shantis103313103shantis
shapen114414653shapen_
shapers124016893shapers
shapes115124953sha_pes
shaping133116183shaping
shard96125963sha_r_d
share86437083sha_r_e
shared105829063sha_red
sharer95025483sha_rer
sharers104720623sharers
sharia93116733sha_ria
shariah132210533shariah
shariahs14206393shariahs
sharif122917123sha_rif
shark126225023sha_r_k
sharp104922533sha_r_p
sharpens13377813sharpens
sharpy145211033sha_rpy
shaughs14245283shaughs
shauls94913113sha_uls
shaven124213303shaven_
shavers134115093shavers
shaves125224933sha_ves
shavies134213213shavies
shaving143414333shaving
shavings15356333shavings
shawing143514883shawing
shawls125411973sha_wls
shawms14579563sha_wms
shawn116417613sha_wn_
shaws116226263sha__ws
shays116021433sha__ys
shearing123915903shearing
shearings13337563shearings
shears93820903shear_s
sheens95116993sh_eens
sheers94322403sheer_s
sheikhs17233993sheikhs
sheiks132510013shei_ks
sheilas1059403sheilas
sheitans1155603sheitans
sherds105614723sh_erds
sherifs13299683sherifs
sherris10168803sherris
shiels95418923sh_iels
shiers94921753sh_iers
shies86136553sh_i_es
shifts124412943sh_ifts
shills94519613sh_ills
shims104422553sh_i_ms
shin75634313sh_i_n_
shine85533093sh_i_ne
shines95028913sh_ines
shinny124810783sh_inny
shiny115122143sh_i_ny
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
shoguns1134423shoguns
shorans102812413shorans
shores94830413sh_ores
shoring112820073shoring
shorings12269483shorings
shorls94516203sh_orls
shorn85722183sh_orn_
shorts95321743sh_orts
shrieks14377673shrieks
shrifts1335963shrifts
shrikes144412393shrikes
shrills10389933shrills
shrimps14516753shrimps
shrine94920053shri_ne
shrines104618693shrines
shrink134511733shri_nk
shrinks14397913shrinks
shris84221453sh__ris
shrives134416173shrives
shticks16356963shticks
shtiks13297833shti_ks
shuns85018143sh__uns
shyers124712203shyer_s
shying134211843shyi_ng
signs65516323s__igns
simians959203simians
sins46755273s__i_ns
sirens65318153s__irens
sires55945373s__ires
sirs44338333s__ir_s
skeins103911903skei_ns
skins94723463s_ki_ns
skirls10449823s_kirls
skirrs10448193s_kirrs
skirts104111503s_kirts
slain54923573slai_n_
smarms105712533sma_rms
smarts86218003sma_rts
smirks124910123s_mirks
snails64816653snai_ls
snares65329033sna_res
snarfs95113423sna_rfs
snaring83920953snaring
snarks104815733sna_rks
snarls64016873sna_rls
soaring83521893soaring
soarings93210393soarings
soars54732513soa_r_s
solions7513753solions
sorns55028423s__orns
sozins15510793sozi_ns
spails84817823spai_ls
spaits85017473spai_ts
spans74528733spa__ns
spares84834553spa_res
sparids103512123sparids
sparing104823873sparing
sparks124616363spa_rks
spars75431543spa_r_s
spavins12419323spavins
spawns11577923spa_wns
speirs85013233speir_s
spins75327983s_pi_ns
spires84628113s_pires
spirts85317133s_pirts
sprains93013593sprai_ns
spurns84811383s_purns
squires163812843squires
squirms18376343squirms
squirts16348013squirts
staigs75414813stai_gs
stain55727943stai_n_
stair54719943stair__
stamens93411483stamens
stares66038753sta_res
staring84527053staring
stars55836573sta_r_s
starts65423123sta_rts
statins73719773statins
stations82415223stations
stearins8312143stearins
steins64818343stei_ns
sterns64616763s_terns
stirks104914243s_tirks
stirps85011823s_tirps
stirs55921623s_tir_s
strains74218153strai_ns
suasions838783suasions
suborns939493suborns
swails94913123swai_ls
swain84919053swai_n_
swans84625013swa__ns
swards105415133swa_rds
swarfs125612063swa_rfs
swarms116112173swa_rms
swirls94010133s_wirls
tains54936323_tai_ns
tarns56433953_ta_rns
thairm1156963thair_m
tharms115712243tha_rms
theins95015423thei_ns
theirs94610353their_s
thins85826333th_i_ns
thirds10438603th_irds
thirls95012063th_irls
thorns95314103th_orns
trains64725343trai_ns
twains95811183twai_ns
unhairs1036373unhair_s
vairs85019133_vair_s
wains86930873_wai_ns
wairs86424063_wair_s
warns87231003_wa_rns
wharfs1546373wha_rfs
whins114922333wh_i_ns
whirls124710533wh_irls
whirrs12408593wh_irrs
whirs115218093wh_ir_s
yairds10448023_yairds
yarns85621793_ya_rns
yearns9509543yea_rns
zaires1539703_zaires

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.390458182.1
2DLD Change Limit1340274165.92322628.2
3Display Results4164160.1402971.4
 (SQL Overall)1786914166.45327691.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.