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

75 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
analyzed2115570(None) 
analysed12166911analysed
analyze19167011analyze_
analyzer20155051analyzer
analyzes20157191analyzes
analyse10208892analyse_
analyser11166132analyser
analyses11149962analyses
analyte10158812analyte_
analytes11169202analytes
analyzers21143662analyzers
banalized21118702banalized
canalized21611692canalized
catalyzed2444992catalyzed
dialyzed2243732dialyzed
paralyzed2445302paralyzed
reanalyzed2352932reanalyzed
unanalyzed2342492unanalyzed
agatized1947073agatized
alkalized23146603alkalized
allayed11138063allay_ed
amazed18519313ama__zed
analogized21155153analogized
analysand1352283analysand
analysers12124603analysers
analysis11128293analysis
analyst10189323analy_st
analysts11167443analysts
analytic1348183analytic
analyzing2245153analyzing
aneled74719283anel__ed
angled84219093angl__ed
animalized2247013animalized
ankled114313483ankl__ed
annoyed1185873annoy_ed
annualized2044613annualized
anodized1946463anodized
anolyte10159003anolyte_
anolytes11169213anolytes
antlered938263antlered
arabized2047173arabized
autolyzed2293873autolyzed
banalize191010933banalize_
banalizes201210093banalizes
canaled103615563canal__ed
canalised12810913canalised
canalize19914493canalize_
canalizes201113783canalizes
canalled1139583canal_led
catalyze2245623catalyze_
catalyzer2344453catalyzer
catalyzes2346053catalyzes
dialysed1344413dialysed
dialyze2044433dialyze_
dialyzer2143113dialyzer
dialyzes2144503dialyzes
dualized1937403dualized
finalized22279243finalized
naled65525053_nal__ed
nasalized1946753nasalized
panelized2147043panelized
paralysed1545743paralysed
paralyze2246633paralyze_
paralyzer2344493paralyzer
paralyzes2346503paralyzes
penalized211210243penalized
realized182514223realized
reanalyze2143233reanalyze_
reanalyzes2243223reanalyzes
tantalized20118923tantalized
unallied938393unallied
unamazed2035883unamazed
unglazed1936263unglazed
vandalized2445813vandalized
waltzed2033493_waltzed

Search took 7 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.406440125.6
2DLD Change Limit146162756.47022590.7
3Display Results75750.0302500.0
 (SQL Overall)178691756.90625874.7
 
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.