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

155 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
semi6512722(None) 
sei36048931se_i
seme65836651seme
semis74623531semis
ami56646812_ami
bema85825252bema
bemix165011452bemix
cedi74919272cedi
defi86321492defi
deli55631292deli
deme76536282deme
demic105119192demic
demit84832302demit
demo77427552demo
demy105422852demy
deni56929392deni
elemi7312502elemi
em49445152_em_
eme55837182_eme
emic86422752_emic
emir65918702_emir
emit65438422_emit
ems56435492_ems
emu55929982_emu
fem86040732fem_
feme96130542feme
fems96428702fems
fermi103914162fermi
gem66840222gem_
gems75329112gems
hem86148732hem_
heme95034412heme
hemic125718622hemic
hemin103620932hemin
hemp115725622hemp
hems95534942hems
kami105823642kami
kemp126418762kemp
kepi105315632kepi
lei36846382le_i
mem77943472mem_
meme85330552meme
memo85924792memo
mems85931502mems
mi48249052__mi
momi87524482momi
nema65522522nema
nevi75116422nevi
peri65636972peri
rami66034092rami
rei35647252re_i
rem56150042rem_
remit75737222remit
remix145916552remix
rems66237722rems
sadi55834642sadi
saki85628482saki
salmi7815862salmi
same65245642same
samp85733592samp
sari45444042sari
sati45539332sati
sea36161292se_a
seal45654372seal
seam66645972seam
seams75731662seams
seamy105921272seamy
sear47353842sear
seas45755272seas
seat47575562seat
sec55945322se_c
secs65033892secs
sect67443622sect
see35772262se_e
seed55549482seed
seek85935482seek
seel45042982seel
seem65438562seem
seems75525022seems
seen46943122seen
seep66540342seep
seer45547042seer
sees45361052sees
seg45544882se_g
segni63712482segni
sego56525182sego
segs54933882segs
seif75638732seif
seis45542392seis
sel38253322se_l
self75138292self
sell45840612sell
sels46345982sels
semen75724102semen
semes75731582semes
semina8915572semina
sen36058522se_n
send55237292send
sene46848052sene
sengi64016512sengi
sent46963012sent
senti56226702senti
sepia75318672sepia
sepic94617052sepic
sept65844362sept
ser36752402se_r
sera46141392sera
serai56830162serai
sere46153472sere
serf76340112serf
serif84132132serif
serin55434442serin
sers45746652sers
set36681252se_t
seta45637312seta
sets45549502sets
sett45949052sett
sew66247262se_w
sewn76124332sewn
sews75836022sews
sex107043222se_x
sext117338092sext
sexy146418022sexy
shim95827862shim
shmo95318102shmo
shri76021702shri
si29149572s__i
sim56553142sim_
sima64730782sima
simp85228772simp
sims65737172sims
ski74925692s_ki
skim105322512skim
slim66631962slim
smew95017732smew
smit65138412s_mit
soli46637012soli
som59153812som_
soma65635292soma
some66040382some
soms66239372soms
sori46039842sori
sri35634002s_ri
stem610628252stem_
stems75219952stems
sum56346012sum_
sumo67326312sumo
sump86331532sump
sums65837582sums
swami105614522swami
swim96221402swim
syli74318982syli
temp85323332temp
tempi94912202tempi
yeti75823212yeti

Search took 2 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 Filter178691298720.263679433.5
2DLD Change Limit298721550.92332364.0
3Display Results1551550.0305166.7
 (SQL Overall)1786911551.216146949.8
 
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.