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 “dynamo” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
dynamo127416(None) 
dynamos1373851dynamos
byname13256362byname
dunam8313732dunam_
dunams937832dunams
dynamic1545812dynamic
dynast1088222dynast
adynamia1443123adynamia
adynamic1643343adynamic
alamo7418143_alamo
bayamo1335603bayamo
bename103316073bename
bynames14256243bynames
camo85731753__camo
cyano105512493cy_ano
dado67126333d__ado
dago65725093d__ago
dam67457043d__am_
dame77140313d__ame
damn75724323d__amn
damp96228843d__amp
dams77444373d__ams
danazol1743253danazol
danio6319783dan_io
dato56129943d__ato
decamp1338453decamp
defame123212433defame
degame102713183degame
degami10279013degami
demo77427553d__emo
denar65223293dena_r
denari710917353denari
denars74621433denars
denary105316863denary
denim85518843denim_
denims95214323denims
diazo15310033d_iazo
didynamy1851423didynamy
digamy1335893digamy
dinar66319893dina_r
dinars75417563dinars
dinero75612643dinero
dingo74720793din_go
dino56036753din__o
diram84419473diram_
dirams94413703dirams
dona55529633dona__
donas65926473dona_s
donate73619503donate
donator8310263donator
dorado838813dorado
dram75832003d_ram_
drama85117413d_rama
drams86025833d_rams
dream85120393dream_
dreams94513983dreams
dreamt94615713dreamt
dreamy12509993dreamy
duomo839753d_uomo
dyad96415453dy_a_d
dyads10549973dy_ads
dynamics1644093dynamics
dynamism1643733dynamism
dynamist1445343dynamist
dynamite1444813dynamite
dynamotor1551523dynamotor
dynasts1155103dynasts
dynasty1463203dynasty
dynatron1243623dynatron
dyne85320933dyn__e
dynein1035563dynein
dynel9569853dyn_el
dynels10536813dynels
dynes95917583dyn_es
dynode1135023dynode
enamor838753_enamor
myna95815303myna__
mynah13569563myna_h
mynahs14416443mynahs
mynas105815233myna_s
nam55953393__nam_
name65637413__name
panama104213353panama
paramo102614643paramo
pyjama20303483pyjama
rename82718813rename
synagog1243623synagog
synanon1044743synanon
syncom1336093syncom
syngamy1643113syngamy
tinamou965013tinamou
whamo135511263_whamo
yam87448993_y_am_
yams95330733_y_ams

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit112716944.78323566.0
3Display Results94940.0303133.3
 (SQL Overall)178691945.18634456.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.