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

129 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
analyses1114996(None) 
analyse10208891analyse_
analysed12166911analysed
analyser11166131analyser
analysers12124601analysers
analysis11128291analysis
analysts11167441analysts
analytes11169201analytes
analyzes20157191analyzes
anabases1038082anabases
anaclises1147862anaclises
analyst10189322analys_t
analyte10158812analyte_
analyze19167012analyze_
analyzed21155702analyzed
analyzer20155052analyzer
analyzers21143662analyzers
anatases839792anatases
anlases72514902an_lases
anolytes11169212anolytes
canalises11515492canalises
catalyses1447432catalyses
dialyses1236132dialyses
paralyses1448282paralyses
reanalyses1343502reanalyses
abacuses1235763abacuses
abalones1038753abalones
abases85720773aba__ses
abatises10311013abatises
acolytes13168043acolytes
agaroses938823agaroses
alkalises13167483alkalises
alkaloses13144853alkaloses
amasses93912853ama_sses
amylases1346663amylases
amyloses1347223amyloses
anabasis1047373anabasis
anabioses1145403anabioses
anablepses1482603anablepses
anaclisis1146043anaclisis
anacruses1145523anacruses
anaglyphs1851543anaglyphs
anagoges10187243anagoges
analcimes1344323analcimes
analcites1147483analcites
analects1047703analects
analgias9107803analgias
analities9715873analities
analogies101910643analogies
analogs82810453anal_ogs
analogues10126183analogues
analysand1352283analysand
analysands1451703analysands
analysing1345933analysing
analytic1348183analytic
analytics1445513analytics
anamneses1144613anamneses
anankes1138763ana_nkes
anapests1046613anapests
anaphases1446523anaphases
anaptyxes2141903anaptyxes
anatase738943anatase_
aneles64626293anel__es
anemoses10159433anemoses
angeluses1045243angeluses
angles74426703angl__es
anilines8415143anilines
animuses1037983animuses
anises64826693an__ises
ankles104818383ankl__es
ankuses1148203an_kuses
ankyloses1644283ankyloses
anlaces92313733an_laces
anlages82414113an_lages
annalists949063annalists
annuluses943913annuluses
anodynes1244443anodynes
anoles64827433anol__es
anolyte10159003anolyte_
antheses11311473antheses
anureses837973anureses
anuses66218773an__uses
atlases72410643a_tlases
autolyses1276523autolyses
avulses1035433avul_ses
balases93815433_balases
banalizes201210093banalizes
biolyses1345573biolyses
calyces14428803_calyces
calyxes19426233_calyxes
canalise10816213canalise_
canalised12810913canalised
canalizes201113783canalizes
catalases1149433catalases
catalysis1445873catalysis
catalysts1445513catalysts
catalyzes2346053catalyzes
dialyse1135463dialyse_
dialysed1344413dialysed
dialyser1243693dialyser
dialysers1343163dialysers
dialysis1245413dialysis
dialyzes2144503dialyzes
encloses10911053encloses
enolases8411013enolases
finalises122911523finalises
incloses101610533incloses
inulases838763inulases
lyses84518253___lyses
metanalyses1653293metanalyses
misanalyses1652263misanalyses
nasalises948113nasalises
oxalises1538503oxalises
paralyse1347483paralyse_
paralysed1545743paralysed
paralysis1447313paralysis
paralyzes2346493paralyzes
penalises11912773penalises
realises82420183realises
reanalysis1352723reanalysis
reanalyzes2243223reanalyzes
taluses7311213_taluses
tantalises101010103tantalises
tantaluses10104593tantaluses
uncloses10910943uncloses
urinalyses1362323urinalyses
valises103516263_valises
valses94514613_val_ses
vandalises1446813vandalises

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621297.42319690.4
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.90522604.8
 
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.