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

171 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
seise5472785(None) 
peise75825771peise
seine55732871seine
seis45542391seis_
seised74218121seised
seiser65318341seiser
seises64026711seises
seism75019021seism
seize143819501seize
sense55526821sense
speise84614251speise
anise55129702anise
arise56436432arise
beige81515372beige
betise85616272betise
bise66437102_bise
cease75227652cease
cense75121402cense
cerise84822042cerise
deice84320032deice
deism84116032deism
deist64633592deist
demise94618322demise
dense65923502dense
devise104215752devise
ease45042332_ease
eide55832232_eide
else45923082_else
fease84824872fease
feist86230072feist
fesse86116332fesse
frise85322452frise
geese64316002geese
guise64717712guise
heist87030912heist
hoise85224772hoise
jesse126012832jesse
lease55230262lease
leis45739602leis_
lense54523432lense
mense75025632mense
mise66043582_mise
neist54628442neist
noise55723732noise
paise75028332paise
pease75231112pease
peised94817682peised
peises84125042peises
perse75429522perse
poise75127892poise
prise74632612prise
raise54828052raise
reis45343232reis_
reive85522942reive
remise84221952remise
rerise64325632rerise
reuse56025362reuse
revise94019742revise
rise45945232_rise
saice75424052saice
seas45755272seas_
secs65033892secs_
sedge75019952sedge
sedile73517232sedile
see35772262se__e
sees45361052sees_
segs54933882segs_
segue6314412segue
sei36048932sei__
seiche11811832seiche
seidel7311082seidel
seif75638732sei_f
seifs85019332seifs
seined74023062seined
seiner64622482seiner
seines65029902seines
seisers73816392seisers
seisin63715122seisin
seisms84912142seisms
seisor63712332seisor
seisure738192seisure
seized164313652seized
seizer154114572seizer
seizes154317532seizes
selle54428312selle
sels46345982sels_
seme65836652se_me
semes75731582semes
semis74623532semis_
semises93916552semises
sene46848052se_ne
senile63420212senile
sensa54117472sensa
sensed73918162sensed
sensei64712592sensei
senses63923942senses
sente56432872sente
sepses84515882sepses
sere46153472se_re
seres55448892seres
serge64727462serge
series64540972series
serine65432672serine
sers45746652sers_
serve85425962serve
setae56026222setae
setose65114772setose
sets45549502sets_
sews75836022sews_
sexes126126222sexes
sexism15227652sexism
sexist133013482sexist
shies86136552shies
shikse1386072shikse
shine85533092shine
shire84727132shire
shist84829602shist
shive114423422shive
sice65545592s_ice
side55444482s_ide
siege66718442siege
sieve84918842sieve
sike87138782s_ike
sine46560622s_ine
sipe67341042s_ipe
sire46150412s_ire
sis37360542s_is_
sises55233832s_ises
site47052412s_ite
size135630962s_ize
skies95026832skies
skis84825282skis_
skite95120042skite
skive124614112skive
slice74925822slice
slide64725412slide
slime74925752slime
slipe75626132slipe
smile74823922smile
smite75224872smite
snide64318722snide
snipe75320572snipe
souse56530772souse
speises93813932speises
speiss84311642speiss
spense83912432spense
spice95528812spice
spies76037622spies
spike114922842spike
spile75230082spile
spine76534422spine
spire75828692spire
spite75430662spite
sris45434152sris_
sties55132982sties
stile54931572stile
stime76521792stime
stipe76523372stipe
suite54829562suite
swine85625302swine
swipe105217082swipe
swish115114822swish
swiss86712902swiss
swive115316192swive
tease55428712tease
tense55225842tense
terse55026822terse
tsetse664692tsetse
verse84723582verse
vise75632672_vise
wise75737342_wise

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.190940478.9
2DLD Change Limit538001712.00026900.0
3Display Results1711710.0463717.4
 (SQL Overall)1786911712.23679915.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.