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 “semis” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

145 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
semis7462353(None) 
seis45542391se_is
semes75731581semes
semi65127221semi_
aegis6316782aegis
amis66445322_amis
bemas96424282bemas
bemist105216962bemist
bemix165011452bemix
cedis84317082cedis
defis96717502defis
delis64928542delis
demes86032692demes
demic105119192demic
demies94825802demies
demise94618322demise
demit84832302demit
demits94918072demits
demos86022992demos
dermis94717162dermis
egis56520652_egis
elemis8312382elemis
emes65434662_emes
emic86422752_emic
emir65918702_emir
emirs76116162_emirs
emit65438422_emit
emits75421472_emits
ems56435492_em_s
emus66821682_emus
femes105626222femes
fems96428702fem_s
fermis114313502fermis
gems75329112gem_s
hemes105031082hemes
hemic125718622hemic
hemin103620932hemin
hemins113417572hemins
hemps126917332hemps
hems95534942hem_s
kemps135012522kemps
kepis115313362kepis
kermis124012392kermis
leis45739602le_is
lenis56326862lenis
levis85818552levis
lewis85315842lewis
lexis125916032lexis
memes94927702memes
memos95719112memos
mems85931502mem_s
metis75025902metis
mis58162622__mis
nemas75321572nemas
penis75129322penis
peris75537072peris
reis45343232re_is
remise84221952remise
remiss84216352remiss
remit75737222remit
remits85622942remits
remix145916552remix
rems66237722rem_s
sadis64930852sadis
sakis95323672sakis
salmis8514272salmis
samps96124672samps
saris54544952saris
satis55633682satis
seals54839692seals
seams75731662seams
sears54744912sears
seas45755272se_as
seats54844342seats
secs65033892se_cs
sects75622892sects
seeds64330062seeds
seeks94724642seeks
seels55632822seels
seems75525022seems
seeps74828752seeps
seers55136382seers
sees45361052se_es
segos64919482segos
segs54933882se_gs
sei36048932se_i_
seif75638732se_if
seifs85019332seifs
seise54727852se_ise
seism75019022se_ism
selfs85220242selfs
sells55134432sells
sels46345982se_ls
seme65836652sem_e
semen75724102semen
semens84616972semens
semina8915572semina
semises93916552semises
sends65528242sends
sepia75318672sepia
sepias83616102sepias
sepic94617052sepic
sepsis83011292sepsis
septs75420602septs
serais64326132serais
seres55448892seres
serfs84922012serfs
series64540972series
serif84132132serif
serifs94017052serifs
serin55434442serin
serins64029672serins
sers45746652se_rs
sets45549502se_ts
setts55124322setts
sews75836022se_ws
sexes126126222sexes
sexism15227652sexism
sexist133013482sexist
sexts125118382sexts
shims104422552shims
shris84221452shris
simas75727552simas
simps94719762simps
sims65737172sim_s
sis37360542s__is
skims114517192skims
skis84825292s_kis
slims75423652slims
smews104612292smews
smit65138412s_mit
somas76030372somas
soms66239372som_s
sris45434152s_ris
stems75219952stem_s
sumos75720092sumos
sumps95023432sumps
sums65837582sum_s
swamis114212292swamis
swims105514142swims
sylis84316022sylis
tamis76728732tamis
temps95417132temps
vermis114214962vermis
yetis85418392yetis

Search took 3 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 Filter178691538000.310576422.6
2DLD Change Limit538001451.64332745.0
3Display Results1451450.0463152.2
 (SQL Overall)1786911451.99989390.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.