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

290 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
semes7573158(None) 
demes86032691demes
emes65434661_emes
femes105626221femes
hemes105031081hemes
memes94927701memes
seems75525021seems
sees45361051se_es
seme65836651seme_
semen75724101semen
semens84616961semens
semis74623531semis
seres55448891seres
sexes126126221sexes
acmes96020652acmes
aedes64625142aedes
almes75126542almes
bees65453382be_es
bemas96424282bemas
benes75536232benes
bermes106023002bermes
beses75830722beses
cames97047312cames
cedes84927322cedes
cees65941592ce_es
cepes94424462cepes
ceres75540012ceres
cetes75731102cetes
comes97246992comes
cremes104517992cremes
cymes1210118922cymes
dames85435852dames
deems85421772deems
dees56356632de_es
dekes105224452dekes
deles65139252deles
deme76536282deme_
demies94825802demies
demos86022992demos
denes65639722denes
dexes135224512dexes
dimes85833042dimes
domes85735562domes
ekes86726602_ekes
eme55837182_eme_
emeu66723432_emeu
emeus76913332_emeus
ems56435492_em_s
emus66821682_emus
eses45336102_eses
esnes54817362esnes
esses56422972esses
eves76230462_eves
ewes76328702_ewes
exes116530812_exes
eyes75837882_eyes
fames105735922fames
feces105625362feces
fees76450602fe_es
feme96130542feme_
femmes135410212femmes
fems96428702fem_s
feres86038182feres
fetes85630142fetes
fezes175220022fezes
fumes105224702fumes
games86238552games
gees55647882ge_es
gems75329112gem_s
genes65133092genes
hames106138702hames
hebes105521672hebes
heme95034412heme_
hemps126917332hemps
hems95534942hem_s
heres86245902heres
hexes155123042hexes
homes106938812homes
jees115938542je_es
jefes155613672jefes
jetes124922842jetes
kames115024692kames
kemps135012522kemps
kermes124616122kermes
kexes166216812kexes
lames75445542lames
lees45455882le_es
leges64427282leges
lenes54738522lenes
leses54930812leses
lexes127225262lexes
limes75636502limes
meme85330552meme_
memos95719112memos
mems85931502mem_s
meres75143572meres
metes74736212metes
mezes167719262mezes
mimes95732022mimes
momes95134472momes
names74833362names
neems77316292neems
nemas75321572nemas
nenes55329672nenes
neumes83112622neumes
neves87021872neves
nomes74933122nomes
pedes85327282pedes
pees65257372pe_es
pekes114623562pekes
peles75738082peles
penes75839222penes
peres76246642peres
pomes94833932pomes
redes65139122redes
rees45364192re_es
reges65628782reges
remet74843722remet
remex146315792remex
rems66237722rem_s
rexes124526952rexes
rhemes115913182rhemes
rimes75634542rimes
sabes76437462sabes
sades65239892sades
safes85226722safes
sages65339062sages
sakes95540752sakes
sales56055592sales
same65245642same_
samek114915272samek
sameks12409322sameks
samps96124672samps
sanes55649072sanes
sates54949322sates
saves85838632saves
saxes125229342saxes
scenes84520352scenes
schemes1489662schemes
seals54839692seals
seamed94823882seamed
seamen84518562seamen
seamer84223612seamer
seamers94719432seamers
seams75731662seams
sears54744912sears
seas45755272se_as
seats54844342seats
secs65033892se_cs
sects75622892sects
seder64826752seder
seders74420282seders
sedges83817792sedges
see35772262se_e_
seed55549482se_ed
seeds64330062seeds
seek85935482se_ek
seeks94724642seeks
seel45042982se_el
seels55632822seels
seem65438562se_em
seemed95117612seemed
seemer84418042seemer
seemers93814332seemers
seen46943122se_en
seep66540342se_ep
seeps74828752seeps
seer45547042se_er
seers55136382seers
segos64919482segos
segs54933882se_gs
segues7412072segues
seifs85019332seifs
seines65029902seines
seis45542392se_is
seise54727852seise
seises64026712seises
seizes154317532seizes
selfs85220242selfs
selles64426982selles
sells55134432sells
sels46345982se_ls
selves94119612selves
sememe10129982sememe
sememes11109202sememes
semi65127222sem_i
semises93916552semises
sends65528242sends
sene46848052sene_
sense55526822sense
senses63923942senses
sepses84515882sepses
septs75420602septs
sere46153472sere_
sered65737292sered
serer55935502serer
serest64831612serest
serfs84922012serfs
serges74225962serges
series64540972series
sers45746652se_rs
serves94423652serves
sesames9310742sesames
sets45549502se_ts
setts55124322setts
seven84118312seven
sevens93813662sevens
sever85426052sever
severs94121122severs
sewed95325162sewed
sewer84426212sewer
sewers94719712sewers
sews75836022se_ws
sexed136618542sexed
sexts125118382sexts
shames114726222shames
shes75734352s_hes
shies86136552shies
shmoes114612092shmoes
shoes85429652shoes
sices75637272sices
sides65838362sides
sieges73816832sieges
siemens938412siemens
sieves93216002sieves
sikes96236082sikes
simas75727552simas
simps94719762simps
sims65737172sim_s
sines55954822sines
sipes76036952sipes
sires55945372sires
sises55233832sises
sites56045432sites
sixes124526362sixes
sizes146727762sizes
skees95023122skees
skenes104616632skenes
skies95026832skies
slimes84722042slimes
sloes54728872sloes
slues54527172slues
smeek114912352smeek
smeeks12428432smeeks
smew95017732s_mew
smews104612292smews
snyes85012752snyes
sokes95031422sokes
soles55547922soles
somas76030372somas
some66040382some_
soms66239372som_s
sones55444142sones
sores55454282sores
spaes76029972spaes
spies76037622spies
spues75025382spues
spumes1021314882spumes
steles63725662steles
stems75219952stem_s
steres63929532steres
sties55132982sties
stimes85920572stimes
styes86316522styes
suedes73918112suedes
sues46247652s_ues
sumos75720092sumos
sumps95023432sumps
sums65837582sum_s
supes75628302supes
swedes102711892swedes
syces106416462syces
sykes124816862sykes
tames75242012tames
teems76019782teems
tees45353582te_es
teles54536002teles
temps95417132temps
themes115319252themes
times75630822times
tomes76037382tomes
vees75439432ve_es
veges94118862veges
vermes115019142vermes
vexes155719122vexes
wames106432802wames
wees76249122we_es
yeses85119322yeses
zees136331892ze_es
zymes1924712942zymes

Search took 4 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.0931921408.6
2DLD Change Limit538002903.40615795.7
3Display Results2902900.0763815.8
 (SQL Overall)1786912903.57549983.5
 
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.