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 “legals” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

63 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
legals7341273(None) 
legal65715941legal_
alegars838932alegars
argals75517712argals
begall92610722begall
begalls10319162begalls
deals65435342de_als
decals93717712decals
degas75119162dega_s
egads74610922_egads
egal55119432_egal_
ferals94216642ferals
gals57946502__gals
heals85733462he_als
illegals954322illegals
lagans75717782lagans
leads66028492le_ads
leafs85721182le_afs
leaks95923912le_aks
leal46043272le_al_
leans55536252le_ans
leaps75522932le_aps
lears55938732le_ars
leas45954182le_a_s
legacy1256652legacy
legalese954752legalese
legalise949492legalise
legalism1148582legalism
legalist9512392legalist
legally1138132legally
legate72917452legate
legates82917682legates
legato72810952legato
legatos82711182legatos
legers74518312legers
leges64427292leg_es
legits71313002legits
legs56133692leg__s
lemans85316392lemans
lethals1038112lethals
levels94113282levels
ligans76817732ligans
locals83714502locals
logans76319062logans
meals75933382me_als
medals94218062medals
megass9219442megass
metals84520892metals
peals75235492pe_als
pedals94316032pedals
petals84719812petals
reals55038652re_als
regal65023792regal_
regale74821452regale
regales83520792regales
seals54839702se_als
sepals85217382sepals
teals56234132te_als
tepals85415042tepals
veals84926192ve_als
vegans103910852vegans
weals85428742we_als
zeals145320852ze_als

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit82551632.50033020.4
3Display Results63630.0163937.5
 (SQL Overall)178691632.87662131.8
 
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.