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

97 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
analyst1018932(None) 
analyse10208891analyse
analysts11167441analysts
analysed12166912analysed
analyser11166132analyser
analyses11149962analyses
analysis11128292analysis
analyte10158812analyte
analyze19167012analyze
anapest9311562anapest
annalist8413752annalist
catalyst1347312catalyst
aals49941143a_al_s_
ablest84721833a_blest
against838383against
alist56136783__alist
allays94313743allays_
amplest11312333amplest
anabas8314083anabas_
anaglyph1751693anaglyph
anal48037523anal___
analcite1049333analcite
analecta1045733analecta
analects1047703analects
analgia898363analgia
anality10313633anality
anally9513503anal_ly
analog7159973anal_og
analogist10410233analogist
analogs82810453analogs
analogy11177853analogy
analysand1352283analysand
analysers12124603analysers
analysing1345933analysing
analytes11169203analytes
analytic1348183analytic
analyzed21155703analyzed
analyzer20155053analyzer
analyzes20157193analyzes
anapaest1046033anapaest
anapests1046613anapests
anas46649863ana__s_
anatase738943anatase
aneles64626293aneles_
anenst63514983an_enst
angles74426703angles_
anglos74413913anglos_
angst6415503an__gst
anils56326723anil_s_
animalist11511643animalist
animist93815173animist
ankles104818383ankles_
anklet105618733ankl_et
anklets114310413anklets
anlas55626933an_las_
annalists949063annalists
annals66415923annal_s_
annoys967523annoys_
anoles64827433anoles_
anolyte10159003anolyte
arbalest1039523arbalest
arbalist10313333arbalist
atavist10311093atavist
atonalist9411833atonalist
avast85519363ava__st
bialys11387913bialys_
cabalist12314503cabalist
canalise10816213canalise
canals84421673canal_s_
catalysts1445513catalysts
dialist8517763dialist
dialyse1135463dialyse
dualist8614053dualist
encyst1136203en_cyst
enlist6417043en_list
fatalist11314973fatalist
finalist113014733finalist
halest94823273_halest
handlist12311333handlist
inanest72115363inanest
inlays9389873inlays_
kabalist14410083kabalist
mayst106622673_ma_yst
nalas55528363_nalas_
nays75931593_na_ys_
onanist7314633onanist
onlays9398713onlays_
oralist7619633oralist
palest83926223_palest
panelist10414503panelist
paralyse1347483paralyse
realest73322433realest
realist73225383realist
sayst85322003_sa_yst
stalest73720173stalest
unblest9411813unblest
unlays93810493unlays_

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.406440125.6
2DLD Change Limit134027977.06018984.0
3Display Results97970.0501940.0
 (SQL Overall)178691977.51623774.7
 
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.