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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
anolyte1015900(None) 
acolyte12157651acolyte
analyte10158811analyte
anolytes11169211anolytes
acolytes13168042acolytes
analyse10208892analyse
analytes11169202analytes
analyze19167012analyze
anodyne1144162anodyne
anole55330382anol__e
ablate82219213a_blate
abollae936943abollae
absolute1044483absolute
aconite9315473aconite
acylate12310533acylate
adulate8313233adulate
aerolite8315053aerolite
alate55340323a__late
amole75724593amol__e
amosite9313163amosite
analcite1049333analcite
anality10313633anality
analysed12166913analysed
analyser11166133analyser
analyses11149963analyses
analyst10189323analyst
analysts11167443analysts
analytic1348183analytic
analyzed21155703analyzed
analyzer20155053analyzer
analyzes20157193analyzes
andante8311273andante
andesyte1243453andesyte
anele55628833anel__e
angle64528873angl__e
anglice1089213anglice
angulate9312013angulate
anile54634463anil__e
aniline7418473aniline
anility10312723anility
animate91617213animate
ankle95220253ankl__e
anklet105618733anklet_
anklets114310413anklets
anlace82513923an_lace
anlage72514233an_lage
annotate877713annotate
annulate8310923annulate
anode65021043ano__de
anodize1738683anodize
anodynes1244443anodynes
anoint6423633anoint_
anointed938343anointed
anointer837823anointer
anoints7311063anoints
anoles64827433anol_es
anomie83215963ano_mie
anomy105113393anomy__
anonym1136383anony_m
anonyms1235443anonyms
ansate64517863an_sate
ante46538903an___te
antlike11312073antlike
apholate13410473apholate
aplite8316393a_plite
apolune945283apolune
areolate81014453areolate
athlete1068083athlete
autolyse1175413autolyse
autolyze2084703autolyze
axolotl1443353axolotl
azole145118033azol__e
azote144416343azo__te
bolete8519613_bolete
canulate10314553canulate
cholate122114933cholate
enolase7310193enolase
evolute1045683evolute
flyte115713943__flyte
folate93320393_folate
gonocyte1454873gonocyte
inflate10312313inflate
inosite7314063inosite
insolate8311893insolate
involute1145473involute
iolite63221983_iolite
isolate7313923isolate
lanoline8311953lanoline
monocyte1547893monocyte
norite63221133_norite
notate63217863_notate
note46239963_no__te
oocyte1135753_oocyte
oolite63319603_oolite
polite83625073_polite
prolate9419793prolate
solate64526073_solate
solute64016663_solute
unpolite1049173unpolite
violate10311553violate
volte85321303_vol_te
volute93912763_volute
zeolite1638903zeolite

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.403443402.0
2DLD Change Limit1340271036.81319672.2
3Display Results1031030.0333121.2
 (SQL Overall)1786911037.24924650.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.