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

250 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
sexes12612622(None) 
dexes135224511dexes
exes116530811_exes
hexes155123041hexes
kexes166216811kexes
lexes127225261lexes
rexes124526951rexes
saxes125229341saxes
sees45361051se_es
semes75731581semes
seres55448891seres
sexed136618541sexed
sexts125118381sexts
sixes124526361sixes
vexes155719121vexes
aedes64625142aedes
apexes1539132apexes
axes117337852_axes
bees65453382be_es
benes75536232benes
beses75830722beses
boxes145625072boxes
cedes84927322cedes
cees65941592ce_es
cepes94424462cepes
ceres75540012ceres
cetes75731102cetes
coxes145430862coxes
dees56356632de_es
dekes105224452dekes
deles65139252deles
demes86032692demes
denes65639722denes
desexes1537832desexes
dexies145018342dexies
ekes86726602_ekes
emes65434662_emes
eses45336102_eses
esnes54817362esnes
esses56422972esses
eves76230462_eves
ewes76328702_ewes
exec135313942_exec
execs14539722_execs
exed125420592_exed
eyes75837882_eyes
faxes155726652faxes
feces105625362feces
fees76450602fe_es
femes105626222femes
feres86038182feres
fetes85630142fetes
fezes175220022fezes
fixes154723592fixes
flexes164512952flexes
foxes156321092foxes
gees55647882ge_es
genes65133092genes
goxes135018262goxes
hebes105521672hebes
hemes105031082hemes
heres86245902heres
hexed165615762hexed
hexer155116682hexer
hexers165612752hexers
ibexes15436162ibexes
ilexes134510252ilexes
jees115938542je_es
jefes155613672jefes
jetes124922842jetes
laxes125430092laxes
lees45455882le_es
leges64427282leges
lenes54738522lenes
leses54930812leses
lexis125916032lexis
loxes125227472loxes
luxes124921502luxes
maxes145629532maxes
memes94927702memes
meres75143572meres
metes74736212metes
mezes167719262mezes
mixes147224402mixes
nenes55329672nenes
neves87021872neves
nexus124710662nexus
nixes124519622nixes
oxes116530722_oxes
paxes144928422paxes
pedes85327282pedes
pees65257372pe_es
pekes114623562pekes
peles75738082peles
penes75839222penes
peres76246642peres
pixes144323172pixes
plexes155313532plexes
poxes145325722poxes
prexes154915942prexes
pyxes175911402pyxes
raxes124729392raxes
redes65139122redes
rees45364192re_es
reges65628782reges
sabes76437462sabes
sades65239892sades
safes85226722safes
sages65339062sages
sakes95540752sakes
sales56055592sales
sanes55649072sanes
sates54949322sates
saves85838632saves
scenes84520352scenes
seals54839692seals
seams75731662seams
sears54744912sears
seas45755272se_as
seats54844342seats
secs65033892se_cs
sects75622892sects
seder64826752seder
seders74420282seders
sedges83817792sedges
see35772262se_e_
seed55549482se_ed
seeds64330062seeds
seek85935482se_ek
seeks94724642seeks
seel45042982se_el
seels55632822seels
seem65438562se_em
seems75525022seems
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
seme65836652seme_
semen75724102semen
semens84616962semens
semis74623532semis
sends65528242sends
sene46848052sene_
sense55526822sense
senses63923942senses
sepses84515882sepses
septs75420602septs
sere46153472sere_
sered65737292sered
serer55935502serer
serest64831612serest
serfs84922012serfs
serges74225962serges
series64540972series
sers45746652se_rs
serves94423652serves
sets45549502se_ts
setts55124322setts
seven84118312seven
sevens93813662sevens
sever85426052sever
severs94121122severs
sewed95325162sewed
sewer84426212sewer
sewers94719712sewers
sews75836022se_ws
sex107043222sex__
sexier13310682sexier
sexiest142112222sexiest
sexism15227652sexism
sexist133013482sexist
sexless1467242sexless
sext117338092sex_t
sextet13916872sextet
sextets1497142sextets
sexto124415452sexto
sextos134012162sextos
sexy146418022sex_y
shes75734352s_hes
shies86136552shies
shoes85429652shoes
sices75637272sices
sides65838362sides
sieges73816832sieges
sieves93216002sieves
sikes96236082sikes
silexes1438652silexes
sines55954822sines
sipes76036952sipes
sires55945372sires
sises55233832sises
sites56045432sites
sixtes133612402sixtes
sizes146727762sizes
skees95023122skees
skenes104616632skenes
skies95026832skies
sloes54728872sloes
slues54527172slues
snyes85012752snyes
sokes95031422sokes
soles55547922soles
sones55444142sones
sores55454282sores
spaes76029972spaes
spies76037622spies
spues75025382spues
steles63725662steles
steres63929532steres
sties55132982sties
styes86316522styes
suedes73918112suedes
sues46247652s_ues
supes75628302supes
swedes102711892swedes
syces106416462syces
sykes124816862sykes
taxes124730822taxes
tees45353582te_es
teles54536002teles
texas126514932texas
texts125515042texts
tuxes124316042tuxes
unsexes14248922unsexes
vees75439432ve_es
veges94118862veges
vexed165713112vexed
vexer155513522vexer
vexers165210402vexers
waxes155825502waxes
wees76249122we_es
yeses85119322yeses
zaxes215113822zaxes
zees136331892ze_es

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.1231452772.4
2DLD Change Limit538002501.89028465.6
3Display Results2502500.0803125.0
 (SQL Overall)1786912502.09385375.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.