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

409 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
sixmo144830(None) 
sixmos1534811sixmos
gismo848862gismo
gizmo1756012gizmo
limo65529732li_mo
schmo124510202schmo
sexto124415452sexto
shmo95318092s_hmo
sicko115315392sicko
sigma84513822sigma
silo46037912si_lo
sim56553132si_m_
sima64730782si_ma
simp85228772si_mp
sims65737172si_ms
six105339742six__
sixes124526362sixes
sixte126216582sixte
sixth155512232sixth
sixty154912732sixty
skimo116312532skimo
sumo67326312s_umo
aim57858213ai_m_
aims67738183ai_ms
alamo7418143alamo
ammo85520133_ammo
axiom143913593axiom
bilbo95513613bilbo
bima86723833bi_ma
bimbo114811873bimbo
bingo86020093bingo
bio57846083bi__o
biome94916993biome
biro66131213bi_ro
bromo95217203bromo
buxom1647153buxom
camo85731753_camo
chemo12313633chemo
ciao64924183ci_ao
cisco95112133cisco
demo77427553_demo
diazo15310033diazo
dido66528193di_do
dildo71911773dildo
dim68146493di_m_
dime76237643di_me
dims75435023di_ms
dingo74720793dingo
dino56036753di_no
dipso85111553dipso
disco85616073disco
disme85716243disme
ditto65315603ditto
dixit134420593dixit
duomo839753duomo
expo1349183_expo
fico95824593fi_co
fido87726393fi_do
fillo84319783fillo
film94828173film_
filmi105914003filmi
films105617963films
filmy136114043filmy
filo76034283fi_lo
fino76034693fi_no
firm96026453firm_
firms105217423firms
fix136236103fix__
fixed165416953fixed
fixer154717833fixer
fixes154723593fixes
fixit154819303fixit
fixt1410729713fix_t
gimme102411343gimme
gimp96124043gi_mp
ginzo1539613ginzo
giro55828633gi_ro
gismos957183gismos
gizmos1844133gizmos
hillo84721653hillo
him86247653hi_m_
hims95230973hi_ms
hippo12369063hippo
homo96126473_homo
iamb86623733_iamb
immy114611833_immy
imp76626973_i_mp
info75617353_info
inro45920793_inro
into45026153_into
ism56322383_ism_
isms66213473_isms
ixia115713213_ixia
jiao115017843ji_ao
jimmy19538503jimmy
jimp155618463ji_mp
jingo134615213jingo
jism135514773jism_
jisms14458003jisms
kiddo11398943kiddo
kilo86028663ki_lo
kino86233613ki_no
lido56028153li_do
lilo46731563li_lo
lima65734133li_ma
limb85429383li_mb
limbo95614813limbo
lime66244933li_me
limn66527693li_mn
limos75320813li_mos
limp88432493li_mp
limy95727713li_my
lingo66022113lingo
lino46343373li_no
litho86513783litho
memo85924793_memo
micro94715993micro
milo65536103mi_lo
mim76048423mi_m_
mime85736403mi_me
mimeo96018683mimeo
misdo85413183misdo
miso67229903mi_so
mix126138183mix__
mixed155717253mixed
mixer145017643mixer
mixes147224403mixes
mixt136831923mix_t
mixup1636773mixup
mo49158483___mo
nim57142953ni_m_
nims66226883ni_ms
nitro54914353nitro
nix106932833nix__
nixe115722023nix_e
nixed135714223nixed
nixes124519623nixes
nixie125114943nixie
nixy145714513nix_y
oxim131114043oxim_
oxime1498433oxime
oxims14107643oxims
oxo107322963_ox_o
piano76118713piano
pigmy13299433pigmy
pima85428653pi_ma
pimp106024903pi_mp
pingo87122713pingo
pinko115618253pinko
pinto75625753pinto
pisco96314983pisco
piso66727563pi_so
pix126437933pix__
pixel143911903pixel
pixes144323173pixes
pixie145415523pixie
pixy166117763pix_y
pomo85828453_pomo
primo95017913primo
promo95619993promo
rim56052273ri_m_
rime65138883ri_me
rims65936303ri_ms
rimy96621283ri_my
sago56332673s_ago
salmi7815863salmi
salmon84614183salmon
salvo84415643salvo
sambo95118013sambo
same65245643s_ame
samp85733593s_amp
santo56227283santo
sargo65424413sargo
sax107447643sax__
saxes125229343saxes
scam85932353scam_
scamp115717313scamp
scams94423973scams
schmoe13328333schmoe
schmos13379153schmos
scudo85412213scudo
scum85924523scum_
scums95017423scums
seam66645973seam_
seams75731663seams
seamy105921273seamy
secco9312423secco
seem65438563seem_
seems75525023seems
segno64814743segno
sego56525183s_ego
seism75019023seism_
seisms84912143seisms
seme65836653s_eme
semi65127223s_emi
sermon8413553sermon
servo84516683servo
sex107043223sex__
sexed136618543sexed
sexes126126223sexes
sexpot1539543sexpot
sext117338093sex_t
sexton133610793sexton
sextos134012163sextos
sexts125118383sexts
sexy146418023sex_y
shako125516083shako
sham96436353sham_
shame105726703shame
shamos114216983shamos
shamoy14379913shamoy
shams105829413shams
shim95827843shim_
shimmy16306413shimmy
shims104422543shims
shoo75929883s_hoo
si29149573si___
sial45938833si_al
sials54227243sials
sib56850313si__b
sibb85921423si_bb
sibbs96211903sibbs
sibs65933543si_bs
sibyl1037113sibyl
sic55847873si__c
sice65545593si_ce
sices75637273sices
sick106435573si_ck
sickos125112033sickos
sicks115127623sicks
sics65234093si_cs
side55444483si_de
sided74825953sided
sides65838363sides
sidh86222983si_dh
sidhe95315103sidhe
sidle65124033sidle
siege66718443siege
sieur5911893sieur
sieve84918843sieve
sift710740663si_ft
sifts84918923sifts
sigh85625893si_gh
sighs95416743sighs
sight94629293sight
sigil63515503sigil
sigla64515203sigla
sigloi737733sigloi
siglos7311463siglos
sigmas94111353sigmas
sigmoid1146093sigmoid
sign55523053si_gn
signa66114703signa
signor73510353signor
signs65516323signs
sika86021323si_ka
sikas94617023sikas
sike87138783si_ke
siker95326033siker
sikes96236083sikes
sild55030583si_ld
silds65520523silds
silex123417413silex
silk85529323si_lk
silks94620683silks
silky125315823silky
sill45545153si_ll
sills55135983sills
silly84527613silly
silos56029423silos
silt46558193si_lt
silts55330823silts
silty84721633silty
silva82714023silva
simar74920813simar
simas75727553simas
simmer104115353simmer
simony1137903si_mony
simoom1037493simoom
simoon858063simoon
simps94719763simps
sin36265893si__n
since75024173since
sine46560623si_ne
sines55954823sines
sinew84718923sinew
sing57544173si_ng
singe65731133singe
sings65532703sings
sinh76238043si_nh
sinhs86719603sinhs
sink86640143si_nk
sinks95529183sinks
sins46755273si_ns
sinus55523853sinus
sip57656013si__p
sipe67341043si_pe
siped84927683siped
sipes76036953sipes
siphon1138463siphon
sips65740103si_ps
sir35746673si__r
sire46150413si_re
sired66134283sired
siree55238813siree
siren54525823siren
sires55945373sires
sirra54416323sirra
sirs44338333si_rs
sirup74014913sirup
sis37360543si__s
sisal54217733sisal
sises55233833sises
sissy85812073sissy
sit35877753si__t
sitar54820543sitar
sitcom1036893sitcom
site47052413si_te
sited65130743sited
sites56045433sites
sith75435153si_th
sits45050203si_ts
situp74414063situp
situs55019233situs
siver85728613siver
sixfold1842723sixfold
sixtes133612403sixtes
sixths16416373sixths
sizar145214993sizar
size135630963si_ze
sized155519243sized
sizer145521813sizer
sizes146727763sizes
sizy164816393si_zy
skidoo1136093skidoo
skim105322493skim_
skimos12548803skimos
skimp135411313skimp
skims114517183skims
slam67737973slam_
slams74927903slams
slim66631953slim_
slime74925753slime
slims75423653slims
slimy105417423slimy
slum65430513slum_
slump94816633slump
slums74623433slums
smog76317413s__mog
so28855443s___o
socko115215113socko
sodom8814903sodom
soldo67116563soldo
solo45538943s_olo
som59153803s_om_
soma65635293s_oma
some66040383s_ome
soms66239373s_oms
sorgo64719723sorgo
sox106444193sox__
spado83713703spado
spam85930043spam_
spams94922193spams
spinto8410663spinto
spume95817313spume
spumy124610363spumy
stamp95217363stamp
stem610628243stem_
stems75219953stems
steno54716863steno
stigma9226753stigma
stime76521793stime
stimy105114733stimy
stingo74212163stingo
stinko10499393stinko
stoma75918273stoma
stomp95616663stomp
stum65526013stum_
stump94616463stump
stums75320083stums
stymy13358293stymy
sulfo8313363sulfo
sum56346013s_um_
summa94713313summa
summon1037623summon
sumos75720093s_umos
sump86331533s_ump
sums65837583s_ums
swam96329983swam_
swami105614523swami
swamp125015323swamp
swamy136714403swamy
swim96221393swim_
swimmy16234353swimmy
swims105514143swims
swum96416823swum_
sybo9714743s_ybo
time66235013ti_me
tiro46832363ti_ro
video96014953video
vim87437023vi_m_
vims95423313vi_ms
vino76128433vi_no
vireo84816453vireo
vixen153010023vixen
whamo135511263whamo
wilco1039443wilco
wimp115521523wi_mp
wino75933613wi_no

Search took 5 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 Filter178691836670.1101624463.6
2DLD Change Limit836674094.59318216.2
3Display Results4094090.1103718.2
 (SQL Overall)1786914094.81337126.7
 
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.