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

126 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
analyse1020889(None) 
analysed12166911analysed
analyser11166131analyser
analyses11149961analyses
analyst10189321analyst
analyte10158811analyte
analyze19167011analyze
analysers12124602analysers
analysis11128292analysis
analysts11167442analysts
analytes11169202analytes
analyzed21155702analyzed
analyzer20155052analyzer
analyzes20157192analyzes
anatase738942anatase
anolyte10159002anolyte
canalise10816212canalise
dialyse1135462dialyse
paralyse1347482paralyse
aals49941143a_al_s_
abalone938903abalone
abase76023483aba__se
acaulose1044383acaulose
acolyte12157653acolyte
agarose838673agarose
alkalise12178043alkalise
allays94313743allays_
amylase1237023amylase
amylose1237193amylose
anabas8314083anabas_
anabases1038083anabases
anaclises1147863anaclises
anaglyph1751693anaglyph
anagoge9166643anagoge
anal48037523anal___
analcime1245393analcime
analcite1049333analcite
analgia898363analgia
anality10313633anality
anally9513503anal_ly
analog7159973anal_og
analogs82810453analogs
analogue9136253analogue
analogy11177853analogy
analysand1352283analysand
analysing1345933analysing
analytic1348183analytic
analyzers21143663analyzers
ananke1038283ana_nke
anankes1138763anankes
anapest9311563anapest
anaphase1345463anaphase
anas46649863ana__s_
anatases839793anatases
anele55628833anel__e
aneles64626293aneles_
angle64528883angl__e
angles74426703angles_
anglice1089213anglice
anglos74413913anglos_
angulose945173angulose
anile54634463anil__e
aniline7418473aniline
anils56326723anil_s_
anise55129713an__ise
ankle95220253ankl__e
ankles104818383ankles_
ankylose1544173ankylose
anlace82513923an_lace
anlaces92313733anlaces
anlage72514233an_lage
anlages82414113anlages
anlas55626933an_las_
anlases72514903an_lases
annalist8413753annalist
annals66415923annal_s_
annoys967523annoys_
annulose844473annulose
anodyne1144163anodyne
anole55330383anol__e
anoles64827433anoles_
anolytes11169213anolytes
antlike11312073antlike
anywise1345203anywise
autolyse1175413autolyse
avulse935843avul_se
banalize191010933banalize
bialys11387913bialys_
canalised12810913canalised
canalises11515493canalises
canalize19914493canalize
canals84421673canal_s_
catalase1039223catalase
catalyses1447433catalyses
catalyst1347313catalyst
catalyze2245623catalyze
dialysed1344413dialysed
dialyser1243693dialyser
dialyses1236133dialyses
dialyze2044433dialyze
enclose9910003enclose
enolase7310193enolase
false84818123_fal_se
finalise113112573finalise
inclose9910223inclose
inlays9389873inlays_
inulase739413inulase
lyse76320593___lyse
nalas55528363_nalas_
nasalise848863nasalise
nays75931593_na_ys_
onlays9398713onlays_
paralysed1545743paralysed
paralyses1448293paralyses
paralyze2246633paralyze
penalise101013763penalise
realise73021813realise
reanalyses1343503reanalyses
reanalyze2143233reanalyze
tantalise91210823tantalise
unalike11311533unalike
unclose91111643unclose
unlays93810493unlays_
valise92917653_valise
valse85117523_val_se
vandalise1347673vandalise

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 Limit1340271267.15618729.3
3Display Results1261260.0462739.1
 (SQL Overall)1786911267.60823487.3
 
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.