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

74 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
analysts1116744(None) 
analyses11149961analyses
analysis11128291analysis
analyst10189321analyst_
analects1047702analects
analyse10208892analys_e
analysed12166912analysed
analyser11166132analyser
analysers12124602analysers
analyte10158812analy_te
analytes11169202analytes
analyzes20157192analyzes
anapests1046612anapests
annalists949062annalists
catalysts1445512catalysts
anabases1038083anabases
anabasis1047373anabasis
anaclises1147863anaclises
anaclisis1146043anaclisis
anaglyphs1851543anaglyphs
analcite1049333analcite
analcites1147483analcites
analecta1045733analecta
analgias9107803analgias
anality10313633anal_ity
analogists1147313analogists
analogs82810453anal_ogs
analysand1352283analysand
analysands1451703analysands
analysing1345933analysing
analytic1348183analytic
analytics1445513analytics
analyze19167013analy_ze
analyzed21155703analyzed
analyzer20155053analyzer
analyzers21143663analyzers
anapaests1143233anapaests
anapest9311553anapest_
anatases839793anatases
angsts738863an__gsts
animalists1258243animalists
animists103010633animists
anklets114310413ankl_ets
anlases72514903an_lases
annalist8413753annalist_
anolyte10159003anoly_te
anolytes11169213anolytes
arbalests1144123arbalests
arbalists1148483arbalists
atavists1137583atavists
atonalists1048493atonalists
cabalists1339153cabalists
canalises11515493canalises
catalyses1447433catalyses
catalysis1445873catalysis
catalyst1347313catalyst_
dialists9411413dialists
dialyses1236133dialyses
dialysis1245413dialysis
dualists958243dualists
encysts1244313en_cysts
enlists749393en_lists
fatalists12310023fatalists
finalists123010163finalists
handlists1347133handlists
kabalists1546293kabalists
onanists838413onanists
oralists8611803oralists
panelists1148343panelists
paralyses1448283paralyses
paralysis1447313paralysis
realists83014843realists
reanalyses1343503reanalyses
reanalysis1352723reanalysis

Search took 9 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.453394461.4
2DLD Change Limit146162747.51619446.8
3Display Results74740.0302466.7
 (SQL Overall)178691747.99922339.2
 
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.