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

106 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
analyte1015881(None) 
analyse10208891analyse
analytes11169201analytes
analyze19167011analyze
anolyte10159001anolyte
acolyte12157652acolyte
analcite1049332analcite
anality10313632anality
analysed12166912analysed
analyser11166132analyser
analyses11149962analyses
analyst10189322analyst
analysts11167442analysts
analytic1348182analytic
analyzed21155702analyzed
analyzer20155052analyzer
analyzes20157192analyzes
anolytes11169212anolytes
abalone938903abalone
abate76627843aba__te
ablate82219213a_blate
acolytes13168043acolytes
acylate12310533acylate
adnate72913483adna__te
adulate8313233adulate
agamete1037403agamete
agate66525153aga__te
agnate73314883agna__te
alate55340323__alate
anaglyph1751693anaglyph
anagoge9166643anagoge
anal48037523anal___
analcime1245393analcime
analcites1147483analcites
analecta1045733analecta
analects1047703analects
analgia898363analgia
analities9715873analities
anally9513503anal_ly
analog7159973anal_og
analogs82810453analogs
analogue9136253analogue
analogy11177853analogy
analysers12124603analysers
analysis11128293analysis
analytics1445513analytics
analyzers21143663analyzers
ananke1038283ana_nke
anatase738943anatase
anatto6139913ana_tto
andante8311273andante
andesyte1243453andesyte
anele55628833anel__e
angle64528873angl__e
anglice1089213anglice
angulate9312013angulate
anile54634463anil__e
aniline7418473aniline
anility10312723anility
animate91617213animate
ankle95220253ankl__e
anklet105618733anklet_
anklets114310413anklets
anlace82513923an_lace
anlage72514233an_lage
annulate8310923annulate
anodyne1144163anodyne
anole55330383anol__e
ansate64517863an_sate
ante46538903an___te
antlike11312073antlike
apatite9312963apatite
aplite8316393a_plite
athlete1068083athlete
banality1338763banality
banalize191010933banalize
baryte115312883_baryte
canalise10816213canalise
canalize19914493canalize
canulate10314553canulate
catalyze2245623catalyze
dealate83617843dealate
dialyse1135463dialyse
dialyze2044433dialyze
egalite8311563egalite
enate54428153ena__te
exabyte1943523exabyte
fayalite1447053fayalite
flyte115713943__flyte
halite93624233_halite
hyalite13229473hyalite
inflate10312313inflate
lanate6421263lana__te
malate84624553_malate
oxalate1457623oxalate
palate84226783_palate
paralyse1347483paralyse
paralyze2246623paralyze
reanalyze2143233reanalyze
salute64418023_salute
tantalate9107373tantalate
tantalite91010863tantalite
unakite1138743unakite
unalike11311533unalike
uralite71714103uralite
vanadate1245513vanadate

Search took 10 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.406440125.6
2DLD Change Limit1340271069.26614464.4
3Display Results1061060.0462304.3
 (SQL Overall)1786911069.71818387.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.