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

141 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
loden6662114(None) 
coden86128541coden
laden65022191laden
lode56240111lode_
lodens74315061lodens
lodes66436911lodes
louden73711791louden
olden65114851olden
bode75838752bode_
boded95124962boded
bodes84935102bodes
cloven114211512cloven
code77347732code_
codec107120342codec
coded95433182coded
codein94916712codein
codens94821012codens
coder86134212coder
codes86247292codes
codex155817572codex
codon86522852codon
copen94826432copen
coven106925042coven
cozen165019702cozen
den47554342__den
doven94718552doven
doyen95014412doyen
dozen155017472dozen
elodea738672elodea
godet7530042godet
golden84411152golden
hodden113811452hodden
hoiden103612332hoiden
holden104113952holden
hosen85623882hosen
hoyden13328932hoyden
iodin64419342iodin
lade56345982lade_
laded74232612laded
ladens74516232ladens
lader65633722lader
lades65141272lades
laten54328342laten
leaden74515222leaden
leben7314852leben
lien45339802l_ien
liken911818842liken
limen75426032limen
linden7411452linden
linen55728722linen
liven85021732liven
loaded84616872loaded
loader74316302loader
loan47436452lo_an
lobe65535362lobe_
lobed86022132lobed
lobes75331002lobes
lodge76520082lodge
lodged913815702lodged
lodger86517682lodger
lodges86820142lodges
logan68123282logan
loge56837192loge_
loges66534202loges
login66025002login
logon615922312logon
loided83414022loided
loin46838722lo_in
lomein8410202lomein
loment84021472loment
lone45849132lone_
loner55431032loner
looed64626132looed
looey84822912looey
loon47344792lo_on
loosen66615962loosen
lope65941922lope_
loped85128332loped
loper75129232loper
lopes76437342lopes
loran55925092loran
lorded84916732lorded
lore45850352lore_
lores55045402lores
lorn46435252lo_rn
lose45144582lose_
losel54419422losel
loser54728672loser
loses56742012loses
loudens8368052loudens
louder74414602louder
loupen84510292loupen
love75234762love_
loved95021362loved
lover85526452lover
loves85332012loves
lowe75435312lowe_
lowed95233902lowed
lower85830412lower
lowes85732462lowes
lown76929292lo_wn
loxed135017052loxed
loxes125227472loxes
lude55331642lude_
ludes65728852ludes
lumen75220902lumen
mode75840302mode_
model84521692model
modem103717142modem
modern939522modern
modes85537412modes
node513036882node_
nodes64633492nodes
nomen75621622nomen
ode47446582_ode_
odea56224572_odea
odeon6411482_odeon
odes57243242_odes
older65121172older
omen66828182_omen
open66427002_open
oven76624142_oven
oxen116218592_oxen
rode55844302rode_
rodent7519242rodent
rodeo65921092rodeo
rodes614039082rodes
rodmen939712rodmen
rouen54920902rouen
roven85521972roven
rowen84921152rowen
sloven9389632sloven
sodden84011512sodden
token95419312token
vodun937222vodun
widen94717972widen
woken124614972woken
women104619252women
wooden103610302wooden
woven115215172woven
yodel94714082yodel

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 Limit538001411.73630990.8
3Display Results1411410.0463065.2
 (SQL Overall)1786911411.87595301.9
 
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.