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

245 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
deter6502804(None) 
dater65332311dater
deer56739021de_er
defer94619751defer
defter104215921defter
deters74724681deters
dexter143810891dexter
dieter73516771dieter
doter65428621doter
meter75130321meter
peter74427591peter
adepter1036112adepter
aether94213672aether
after85719792after
alter54828502alter
apter76120202apter
aster55434892aster
beater84729392beater
beer65635992be_er
belter84720962belter
betel74419902betel
better84723702better
biter75030032biter
cater74840702cater
ceder85322232ceder
center84421412center
cete64934782cete_
cetes75731102cetes
citer74827322citer
cuter74728222cuter
dafter104813342dafter
darer65230792darer
darter75320362darter
date56443322date_
dated75530992dated
daters74827362daters
dates65639152dates
deader84220472deader
deafer104114812deafer
deair65817192deair
dealer74122142dealer
dear55343602de_ar
dearer74822802dearer
debar85517862debar
debater104114692debater
debtor938332debtor
decern91310952decern
decker135215992decker
decor84717572decor
dee47665822de_e_
deed65340902de_ed
deem75432892de_em
deep76031882de_ep
deeper93613502deeper
deers64930522de_ers
dees56356632de_es
deet57356582de_et
deets65330242deets
defers105116942defers
deffer134411302deffer
defier105118652defier
degerm1037892degerm
deicer94114412deicer
deke95228762deke_
deked115718532deked
dekes105224452dekes
dele56843082dele_
deled75326542deled
deles65139252deles
delver104913492delver
deme76536282deme_
demes86032692demes
demur8311162demur
denar65223292denar
dene56643412dene_
denes65639722denes
denier74420692denier
denser74115192denser
dented84120512dented
deperm1139362deperm
dere56845902dere_
desert72725492desert
desex13311982desex
detect94217402detect
detent73624482detent
deterge9118462deterge
detest74122842detest
detour778192detour
detox13310952detox
devel94217122devel
dewar95817732dewar
dewater112912422dewater
dewed105020302dewed
dewier104013462dewier
dexes135224512dexes
dicer85426422dicer
diester83013682diester
dieted83115492dieted
dieters83216422dieters
diether1147442diether
diker105524552diker
dimer85625602dimer
dimeter10411892dimeter
diner65632902diner
direr64927072direr
dite55547552dite_
dites66339152dites
dither104417682dither
diver94827802diver
doer57734702d_oer
doper86128392doper
doser66228562doser
dote55442882dote_
doted75227072doted
doters74423912doters
dotes65836692dotes
dotier73917032dotier
dotter74419342dotter
dower95027702dower
dozer158419272dozer
drier64423962drier
dryer95111462dryer
dueler74213682dueler
dueted84113592dueted
duper85519002duper
duster74919722duster
dyer85522112d_yer
eater54639842eater
edger75215932edger
eger55923562_eger
enter54726382enter
ester54727712ester
ether84518772_ether
ever77027692_ever
ewer77523982_ewer
eyer76127282_eyer
feater95224052feater
fester94723512fester
fete75734922fete_
feted94420932feted
fetes85630142fetes
fetor81214532fetor
fetter94120382fetter
fever115617952fever
fewer115216122fewer
feyer115014522feyer
gater64533642gater
getter74117612getter
hater85034752hater
heater94828302heater
heder95623632heder
hefter124313922hefter
hetero9312632hetero
hewer115719932hewer
hexer155116682hexer
inter55028492inter
jeer115426462je_er
jester134319152jester
jete115927252jete_
jetes124922842jetes
kelter103214372kelter
kiter95523212kiter
later54843922later
leer46239352le_er
lefter93613432lefter
leger65721502leger
leper74820742leper
letter63722582letter
lever85125162lever
liter54736342liter
mater74438862mater
meeter83616502meeter
melter83520112melter
merer75126232merer
mete64438132mete_
meted85424432meted
meteor84910072meteor
meters85625832meters
metes74736212metes
metier83517692metier
metre74821302metre
miter75734792miter
muter74525542muter
neater64424312neater
nester64124182nester
nether94014162nether
netter63722022netter
neuter63713792neuter
never86218642never
newer85717462newer
niter55028972niter
noter55025642noter
oater55433732oater
ofter84116872ofter
otter54423972otter
outer55633302outer
oxter123414092oxter
pater74740722pater
peer66238352pe_er
pelter83321622pelter
perter84422282perter
pester84827592pester
peters86624592peters
petter83924772petter
pewter114013672pewter
rater54943282rater
refer84822142refer
renter64527412renter
rester63832432rester
rete44944132rete_
retear63115482retear
retem74221952retem
seater64534152seater
seder64826752seder
seer45547042se_er
serer55935502serer
setter64023722setter
sever85426052sever
sewer84426212sewer
steer55423862steer
tater54138612tater
teeter65420312teeter
tenter64623932tenter
tester64227152tester
tether93716102tether
tetter64322452tetter
titer55430612titer
toter55932132toter
ureter6313202ureter
utter54218762utter
veer76229572ve_er
venter94218722venter
vetoer93410062vetoer
vetter93417642vetter
vexer155513522vexer
voter85121052voter
water84733312water
weber10313522weber
weer75535092we_er
welter93417382welter
wester94222892wester
wether123315392wether
wetter93919442wetter
yester93417982yester
zester153617792zester

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 Filter178691538000.0931921408.6
2DLD Change Limit538002451.71631352.0
3Display Results2452450.0633888.9
 (SQL Overall)1786912451.87295454.6
 
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.