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

73 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
loessal74439(None) 
loessial843781loessial
dossal75510302do_ssal
glossal8447052glo_ssal
loess55714702loess__
loesses7310032loesses
abyssal1243763abyssal
borstal939043borstal
byssal1134993_byssal
coastal9411043coastal
coequal1844933coequal
coeval1138893coe_val
colossal1045553colossal
costal85419513co_stal
crestal9312133crestal
crissal937413crissal
dorsal74613943do_rsal
dossals8379293do_ssals
dossel74813643do_ssel
dossil75110903do_ssil
essay867623__essay
festal94213563_festal
foetal9311883foe_tal
forestal11410283forestal
fossa85812633fo_ssa_
fossae95510373fo_ssae
fossas94610703fo_ssas
fossil9379353fo_ssil
glossa7529163glo_ssa_
glossae8477283glo_ssae
glossas8438193glo_ssas
gossan747233go_ssan
leal46043273l_e__al
legal65715943l_e_gal
less45635103l_ess__
lessee64116363l_essee
lessen64212433l_essen
lesser63514853l_esser
lesson64412043l_esson
lessor64010603l_essor
lethal939803l_ethal
lienal63912783lie_nal
local74820273lo__cal
lochial1257083lochial
locustal10325223locustal
lodestar944413lodestar
logical1038513logical
loral55927823lo__ral
loreal63814313lo_real
losel54419423lo__sel
loses56742013loses__
loss45337963lo_ss__
losses65925233lo_sses
lossy85214643lo_ss_y
loveseat1145783loveseat
loyal84513483lo__yal
lyssa835713l_yssa_
lyssas935443l_yssas
mensal84615663_mensal
mescal104113493_mescal
mesial84818083_mesial
messan83912063_messan
missal84314903_missal
ossa43714163_o_ssa_
postal84317533po_stal
reseal64819643_reseal
tressel73010893tressel
tussal6288323_tussal
vassal979243_vassal
versal93013753_versal
vessel937953_vessel
vestal94615573_vestal
zoeal144813783zoe__al

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.453394461.4
2DLD Change Limit134027736.97019229.1
3Display Results73730.0302433.3
 (SQL Overall)178691737.45323975.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.