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

93 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
siderites1041043(None) 
siderite9411361siderite_
sclerites1139442sclerites
sidelines10109682sidelines
sideritic1255352sideritic
siderolites1253402siderolites
sideroses1047352sideroses
sienites8311912si_enites
andesites1048563andesites
ankerites1348543ankerites
binderies12311693binderi_es
cerites94823433__cerites
coderives1547483coderives
derates84028893__derates
derides93420853__derides
derives114017813__derives
desiderates1345813desiderates
dimerizes2167943dimerizes
diorites9313523di_orites
dolerites101410893dolerites
federates13310153federates
fiberizes2346183fiberizes
fidelities1445933fidelities
fineries112416753fineri_es
hiddenites1552753hiddenites
ideates8313733_ide_ates
iterates81317823_iterates
jadeites1645823jade_ites
kieserites1443643kieserites
laterites9715083laterites
liberates111012953liberates
liberties1149213liberties
literates91415653literates
liveries11314373liveri_es
maderizes2148953maderizes
millerites1247933millerites
mimetites1346823mimetites
miseries10320403miseri_es
miswrites1447983miswrites
moderates12710753moderates
niderings1175403niderings
niteries8318383niteri_es
nitrites82313453ni_trites
picrites121811083pi_crites
pineries102419083pineri_es
piperines131610693piperines
ruderies9311333ruderi_es
sclerite10410713sclerite_
scleritis1146433scleritis
selenites91312093selenites
seriates82620683s__eriates
series64540973s__eri_es
serines74229543s__erines
severities1348523severities
sidehills1343163sidehills
sidekicks1542393sidekicks
sideline91011093sideline_
sidelined11125883sidelined
sideliner10126013sideliner
sideliners11125133sideliners
sidepieces1572893sidepieces
siderolite1153913siderolite_
siderosis1045543siderosis
siderotic1255343siderotic
sidestep1144243side_step
sidesteps1243623side_steps
sideswipes16122643sideswipes
sidewise1245353sidewise_
sienite7312713si_enite_
sincerities1347103sincerities
skywrites1952763skywrites
soberizes2098963soberizes
sodalites10128693sodalites
sodomites12137193sodomites
sorites73825243s__orites
spiceries1349313spiceri_es
spiderier1244653spideri_er
spideriest1345293spideri_est
sprites94220333s__prites
sternites9310073s_ternites
suberises11813453suberises
suberizes20811833suberizes
sudaries9312753sudari_es
sybarites1465933sybarites
syenites1138943s_yenites
tiderips1145383tideri_ps
underbites1347893underbites
verites103822263__verites
videttes1266333vide_ttes
vineries112716043vineri_es
wineries112316533wineri_es
witherites1645973witherites
yperites13310153_yperites

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 Filter1786911486410.436409841.7
2DLD Change Limit148641936.71622132.4
3Display Results93930.0332818.2
 (SQL Overall)178691937.18524870.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.