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

535 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
shairn926906(None) 
shaird10288701shaird
shairns10276781shairns
sharn84823701sha_rn
airn46433832__airn
bairn77515532_bairn
cairn75717512_cairn
chain105723672chai_n
chair105519632chair_
chairs114916172chairs
hair76330142_hair_
hairs86225172_hairs
hairy115316832_hairy
sain45551292s_ai_n
sarin55239252s_arin
shairds11216262shairds
shaitan1036882shaitan
shaken134113612shaken
shaman113314272shaman
shapen114414652shapen
shard96125962sha_rd
share86437082sha_re
sharia93116722sharia
sharif122917112sharif
sharing113723242sharing
shark126225022sha_rk
sharns95516982sha_rns
sharny124711832sha_rny
sharp104922532sha_rp
shaven124213302shaven
shawn116417612sha_wn
shin75634302sh_i_n
shire84727132sh_ire
shirk124817842sh_irk
shirr84716922sh_irr
shirt84533892sh_irt
shorn85722172sh_orn
slain54923572slai_n
stain55727932stai_n
stair54719932stair_
stairs65416332stairs
swain84919052swai_n
thairm1156962thairm
again65218113agai_n
ain37579093__ai_n
air38058393__air_
airns55521033__airns
airs46447423__airs
airt45757783__airt
airy75734153__airy
amain74922883amai_n
bairns86710873_bairns
barn66444643_ba_rn
blain75421793blai_n
brain76229383brai_n
cain65643913_cai_n
caird85717233_caird
cairns85313303_cairns
cairny11557823_cairny
carn66245433_ca_rn
chadri1238133chadri
chagrin1337883chagrin
chai95929903chai__
chaine115119223chaine
chains114819703chains
chaired134211243chaired
chairing143110773chairing
chairman15106373chairman
chairmen15105473chairmen
chais107530313chai_s
chaise114916413chaise
chakra15437533chakra
char95132153cha_r_
chard116124743cha_rd
chare105231983cha_re
charing133721323charing
chark144222713cha_rk
charm126124663cha_rm
charr104821783cha_rr
charro114212953charro
charrs115219183charrs
charry145012113charry
chars105936633cha_rs
chart105038283cha_rt
chary135023133cha_ry
chazan20269133chazan
chin96934743ch_i_n
chirk144516183ch_irk
chirm125317063ch_irm
chiro105320343ch_iro
chirp124717163ch_irp
chirr105015903ch_irr
chiru105317153ch_iru
choir105313593choir_
choirs114911873choirs
churn105113103ch_urn
dairy97016303_dairy
darn56434623_da_rn
deair65817193deair_
deairs74013783deairs
dharna1055263dha_rna
drain65222893drai_n
earn46737553_ea_rn
elain55324703elai_n
fain75840563_fai_n
fair76332523_fair_
fairs85825443_fairs
fairy115318283_fairy
firn76927503__firn
flair86114123flair_
flairs95711913flairs
gain56042163_gai_n
gharri10386163gharri
gharry13546273gharry
girn56026863__girn
glair65313553glair_
glaire74411293glaire
glairs75211333glairs
glairy10448273glairy
grain65126253grai_n
haar77323493_haar_
haars85620473_haars
hadron102913753_hadron
haen76229453_ha_en
haik115526983_hai_k
haika125313793_haika
haiks125120933_haiks
haiku126113693_haiku
hail74839063_hai_l
hails85231643_hails
haint85436323_haint
hairdo1036433_hairdo
haired105117173_haired
hairnet10911703_hairnet
hairpin1245413_hairpin
halon86124863_halon
hard85443503_ha_rd
hare76255733_ha_re
haring104233003_haring
hark115237393_ha_rk
harl75740003_ha_rl
harm95637793_ha_rm
harp96134283_ha_rp
harry115322953_harry
hart76865773_ha_rt
haven114718533_haven
hazan173813613_hazan
heir77523803_heir_
heirs85618563_heirs
hern76134893_h_ern
hin67559563_h_i_n
hire75538963_h_ire
hisn79620933_h_isn
horn76735613_h_orn
kain85334293_kai_n
karn86129413_ka_rn
khan115819143kha__n
khazen2233773khazen
kirn87123433__kirn
lain46146283_lai_n
lair45934153_lair_
laird65417793_laird
lairs55425873_lairs
learn55322663lea_rn
main65345503_mai_n
mair66133763_mair_
mairs76228293_mairs
mohair1135203mohair_
mohairs1234953mohairs
naira5314743_naira
nairu5413813_nairu
pain65647243_pai_n
pair66031513_pair_
pairs75325833_pairs
pirn67128373__pirn
plain74823303plai_n
rain46251733_rai_n
sabin74924943s_abin
sabir75916993sabir_
sabirs85414623sabirs
sabra75317853s_abra
sabre74821503s_abre
sacra74516993s_acra
sadiron836043sadiron
sahib10314753sahi_b
sahibs1137073sahibs
saice75424053s_aice
said55742113s_ai_d
saids65328853s_aids
saiga64717933s_aiga
sail45447163s_ai_l
sails55738103s_ails
saimin8313663s_aimin
sains55639973s_ains
saint55147073s_aint
saith85826553s_aith
salon55228553s_alon
saran53730303s_aran
sard55344243s_a_rd
sari45444043s_a_ri
sarins63932623s_arins
saris54544953s_aris
sark84938973s_a_rk
sasin54626573s_asin
satin55935213s_atin
satire63218003satire
saury84317223s_aury
savarin10310003savarin
savin84625083s_avin
sawn75428163s_a_wn
scan65530453sca__n
scar66434203sca_r_
scare75334463sca_re
scarf105427143sca_rf
scaring103421973scaring
scarp95724103sca_rp
scarry116311183scarry
scars75433533sca_rs
scart76139773sca_rt
scary105222593sca_ry
scaur75814903scaur_
scaurs85512043scaurs
scion72214993s_cion
scorn75817443s_corn
seabird1055363seabird
seagirt8310153seagirt
seaman84015903seaman
seamen84518563seamen
sear47353843sea_r_
searing83330923searing
sears54744913sea_rs
season62714903season
seawan94111223seawan
secern81010223secern
serin55434443seri_n
sha69837783sha___
shabby1635803shabby
shack145321753sha_ck
shacko153810113shacko
shacks154817563shacks
shad86230913sha__d
shade95125583sha_de
shaded114518873shaded
shader104218763shader
shaders115915553shaders
shades105924533shades
shadier113111153shadier
shadily1437723shadily
shading123115563shading
shadow1337253shadow
shads95124483sha_ds
shaduf1337063shaduf
shady125416513sha_dy
shaft115725253sha_ft
shafts125411433shafts
shag86430563sha__g
shaggy14478043shaggy
shagreen1243443shagreen
shags95123863sha_gs
shah105627783sha__h
shahs115919513sha_hs
shaitans1136403shaitans
shake124726403sha_ke
shaker134319463shaker
shakers144015563shakers
shakes135024593shakes
shakier143411153shakier
shakily1736903shakily
shaking153317253shaking
shako125516083sha_ko
shakos134912183shakos
shaky154616843sha_ky
shale85332833sha_le
shaled105023953shaled
shales94731253shales
shaley123714993shaley
shalier103116423shalier
shall85024053sha_ll
shalom11810913shalom
shalt85534483sha_lt
shaly114322863sha_ly
sham96436353sha__m
shamans123610893shamans
shamas113717933shamas
shame105726703sha_me
shamed125120213shamed
shames114726223shames
shaming133016743shaming
shamisen1344273shamisen
shammy16388503shammy
shamos114216983shamos
shamoy14379913shamoy
shams105829413sha_ms
shamus114112813shamus
shandy134710033shandy
shank125422193sha_nk
shanks135315583shanks
shanny124110093shanny
shanti94014073shanti
shanty124715113shanty
shape105125113sha_pe
shaped125020103shaped
shaper114119933shaper
shapers124016893shapers
shapes115124943shapes
shaping133116183shaping
shards104319173shards
shared105829063shared
sharer95025483sharer
sharers104720623sharers
shares95236413shares
shariah132210533shariah
sharias102516003sharias
sharifs13279903sharifs
sharks135019723sharks
sharpen12389723sharpen
sharps115516083sharps
sharpy145211033sharpy
shat76456593sha__t
shaugh13287433shaugh
shaul85418103sha_ul
shauls94913113shauls
shave114425893sha_ve
shaved135118383shaved
shaver123718913shaver
shavers134115093shavers
shaves125224933shaves
shavie124312413shavie
shavies134213203shavies
shaving143414333shaving
shaw108132553sha__w
shawed134817233shawed
shawing143514883shawing
shawl116217573sha_wl
shawls125411973shawls
shawm135316143sha_wm
shawms14579563shawms
shaws116226263sha_ws
shay107133343sha__y
shays116021433sha_ys
shazam2046603shazam
shear85424833shear_
shearing123915903shearing
shears93820903shears
sheen85023313sh_een
sheer84726893sheer_
sheers94322403sheers
sheik122514653shei_k
sheikh16206993sheikh
sheiks132510013sheiks
sheila969843sheila
sheitan1036563sheitan
sherd96321153sh_erd
sherif122915233sherif
sherry124510413sherry
shewn115715703sh_ewn
shied96125493sh_ied
shiel811023773sh_iel
shier85428943sh_ier
shiers94921753shiers
shies86136553sh_ies
shift114225133sh_ift
shill85325333sh_ill
shily115222013sh_ily
shim95827843sh_i_m
shims104422543sh_ims
shine85533093sh_ine
shinny124810783sh_inny
shins85131043sh_ins
shiny115122143sh_iny
ship95228233sh_i_p
ships105123773sh_ips
shires95225573sh_ires
shirks134814123sh_irks
shirrs94413173shirrs
shirts94918333sh_irts
shirty124312553sh_irty
shist84829603sh_ist
shit76745933sh_i_t
shits84731163sh_its
shiv105721163sh_i_v
shiva115915003sh_iva
shive114423423sh_ive
shivs115018803sh_ivs
shoer84722153shoer_
shoers94518323shoers
shogun1045703shogun
shoon84022003sh_oon
shoran94016033shoran
shore85432643sh_ore
shoring112820063shoring
shorl84720243sh_orl
short85040523sh_ort
shown115216473sh_own
shri76021693sh__ri
shriek134211103shriek
shrift12413543shrift
shrike134513243shrike
shrill94712303shrill
shrimp13478763shrimp
shrine94920053shrine
shrink134511733shrink
shris84221443shri_s
shrive125216953shrive
shriven13379653shriven
shtick15308013shtick
shtik123210943shti_k
shtiks13297823shtiks
shuln84713113sh_uln
shun75122773sh__un
shyer114714783shyer_
shyers124712203shyers
shying134211843shying
sign55523053s__ign
simian8811153simian
sin36265893s__i_n
sir35746673s__ir_
sire46150413s__ire
siren54525823s__iren
sirs44338333s__irs
skein94814403skei_n
skin85927523s_ki_n
skirl96012913s_kirl
skirr94810543s_kirr
skirt95624663s_kirt
smarm95517603sma_rm
smart75834093sma_rt
smirk116612743s_mirk
snail57020203snai_l
snails64816653snails
snare54429983sna_re
snarf86525423sna_rf
snaring83920953snaring
snark95419943sna_rk
snarl54921083sna_rl
soar46838673soa_r_
soaring83521893soaring
soars54732513soa_rs
solion6616383solion
sorn46641063s__orn
sozin14514523sozi_n
spail74921553spai_l
spails84817823spails
spait75631603spai_t
spaits85017473spaits
span65234663spa__n
spar65433303spa_r_
spare75135563spa_re
sparid94016933sparid
sparing104823873sparing
spark114920893spa_rk
sparry115111303sparry
spars75431543spa_rs
spavin114210653spavin
spawn107811713spa_wn
speir75315363speir_
speirs85013233speirs
spin66231303s_pi_n
spire75828693s_pire
spirt75032953s_pirt
spiry105017353s_piry
sprain83614863sprai_n
spurn74815453s_purn
squire155912453squire
squirm17387663squirm
squirt153812923squirt
staid66722073stai_d
staig65519633stai_g
staigs75414813staigs
stains64923653stains
stamen84115943stamen
star48037763sta_r_
stare54440263sta_re
staring84527053staring
stark95425623sta_rk
starry94911673starry
stars55836573sta_rs
start55642313sta_rt
statin63921463statin
station72717243station
stearin7312003stearin
stein54620533stei_n
stern55319123s_tern
stir45723243s_tir_
stirk95717413s_tirk
stirp76815503s_tirp
stirs55921613s_tirs
strain64919573strai_n
suasion739363suasion
suborn8310003suborn
swail86217163swai_l
swails94913123swails
swains94513953swains
swan76631313swa__n
sward94221463swa_rd
sware85828213swa_re
swarf115324653swa_rf
swarm106218833swa_rm
swart86234643swa_rt
swirl84514143s_wirl
sworn86115303s_worn
tain45548073_tai_n
tarn46842723_ta_rn
thairms1244453thairms
than76128773tha__n
tharm105916643tha_rm
thein85919023thei_n
their85512153their_
theirs94610353theirs
thin76732383th_i_n
thir76420543th_ir_
third95912493th_ird
thirl85416823th_irl
thorn85318703th_orn
train56529113trai_n
twain86313623twai_n
unhair937333unhair_
unhairs1036373unhairs
vain75233003_vai_n
vair75624143_vair_
vairs85019133_vairs
wain75840193_wai_n
wair75830053_wair_
wairs86424063_wairs
warn75239323_wa_rn
wharf14315823wha_rf
whin105225693wh_i_n
whir105519283wh_ir_
whirl114913823wh_irl
whirr114611193wh_irr
whirs115218093wh_irs
yaird96111913_yaird
yarn75230043_ya_rn
yearn86316433yea_rn
zaire14311993_zaire

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.1231452772.4
2DLD Change Limit1127165356.51617298.3
3Display Results5355350.1733092.5
 (SQL Overall)1786915356.81226231.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.