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

86 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
dynamos137385(None) 
dynamo1274161dynamo_
bynames14256242bynames
dunams937832dunam_s
dynamic1545812dynamic
dynamics1644092dynamics
dynamism1643732dynamism
dynamist1445342dynamist
dynasts1155102dynasts
adynamia1443123adynamia
adynamias1543193adynamias
adynamic1643343adynamic
alamos8415003_alamos
bayamos1434663bayamos
benames112814603benames
byname13256363bynam_e
camos95927613__camos
dados75522433d__ados
dagos76419443d__agos
dames85435853d__ames
damns84916923d__amns
damps105220413d__amps
dams77444373d__am_s
danazol1743253danazol
danazols1843083danazols
danios7314603dan_ios
datos65222783d__atos
decamps1435643decamps
defames132812253defames
degames113312623degames
degamis11268443degamis
demos86022993d__emos
denars74621433dena_rs
denims95214323denim_s
digamous1296063digamous
dinars75417563dina_rs
dineros83812333dineros
dinos65428063din__os
dirams94413703diram_s
donas65926473dona__s
donates83217223donates
donator8310263donator
donators9310403donators
dorados938203dorados
dramas95814663d_ramas
drams86025833d_ram_s
dreams94513983dream_s
dunam8313733dunam__
duomos936823d_uomos
dyads10549973dy_a_ds
dynamisms1743373dynamisms
dynamists1544093dynamists
dynamite1444813dynamite
dynamites1544623dynamites
dynamotor1551523dynamotor
dynamotors1651383dynamotors
dynast1088223dyna_st
dynasty1463203dynasty
dynatron1243623dynatron
dynatrons1343393dynatrons
dyneins1134213dyneins
dynels10536813dyn_els
dynes95917583dyn__es
dynodes1235453dynodes
enamor838753_enamor
enamors939123_enamors
fynbos1433283fyn_bos
mynahs14416443myna_hs
mynas105815233myna__s
names74833363__names
naos47429733__na_os
nomos75919743__nomos
panamas113112763panamas
paramos113213513paramos
pyjamas21263523pyjamas
renames92418053renames
shamos114216983_shamos
synagog1243623synagog
synagogs1343273synagogs
synanon1044743synanon
synanons1144633synanons
syncoms1435943syncoms
syngamous1543393syngamous
tinamou965013tinamou
tinamous1045983tinamous
yams95330733_y_am_s

Search took 8 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 Filter1786911340270.436409841.7
2DLD Change Limit134027867.23318529.9
3Display Results86860.0302866.7
 (SQL Overall)178691867.69923209.6
 
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.