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

88 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
analgias910780(None) 
analgia898361analgia_
anaemias1069202anaemias
analgesias11194062analgesias
analogies101910642analogies
anergias947172anergias
antalgics1245172antalgics
myalgias14123892myalgias
otalgias944182otalgias
aaliis6312903a_al_iis
abasias9711013aba_sias
abelias93213563abel_ias
abulias93210693abul_ias
acacias11510403aca_cias
acapnias1255683acapnias
adagial946373ada_gial
adagios945513ada_gios
algas65624933__alg_as
algins74816433__algins
alias55834603__al_ias
amalgam1244923amalg_am
amalgams1343203amalgams
anabas8314083ana__bas
anaemia959803anaemia_
anagogies11156163anagogies
anagram1058193ana_gram
anagrams1146593ana_grams
analcime1245393analcime
analcimes1344323analcimes
analcite1049333analcite
analcites1147483analcites
analects1047703analects
analemmas13103583analemmas
analgesia10174413analgesia_
analgesics13213423analgesics
analgetics13184363analgetics
analities9715873analities
anality10313633anal_ity
analogic1148613analogi_c
analogical1356363analogical
analogism1256753analogism
analogisms1345213analogisms
analogist10410233analogist
analogists1147313analogists
analogize19156543analogize
analogizes20136033analogizes
analogous1044833analogous
analogs82810453anal_ogs
analogues10126183analogues
analyses11149963analyses
analysis11128293analysis
analysts11167443analysts
analytes11169203analytes
analytics1445513analytics
analyzes20157193analyzes
anaplasias1254663anaplasias
anemias92512143an_emias
anergia847363anergia_
anergies9310453anergies
angarias9310553angarias
angas65827983an__g_as
anginas8310953an__ginas
anilins7416793anil_ins
anlages82414113anlag_es
anlas55626933an_l__as
anopias92412483an_opias
anopsias10337983anopsias
anosmias1056083anosmias
anoxias14259113an_oxias
antalgic1146703antalgi_c
antibias10312083antibias
anurias7312253an_urias
aphagias14237353aphagias
aplasias10279233aplasias
apologias1247503apologias
atalayas1144783atalayas
ataxias14189343ata_xias
azaleas1636993azal_eas
causalgias1352273causalgias
coxalgias1942423coxalgias
kalmias1347973_kalmias
mamaligas1443383mamaligas
myalgia13124293myalgia_
nalas55528363_nal__as
nilgais845203_nilgais
otalgia844483otalgia_
otalgies936393otalgies
salvias10279933_salvias

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.436409841.7
2DLD Change Limit146162887.65619091.2
3Display Results88880.0332666.7
 (SQL Overall)178691888.12521992.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.