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

74 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
liege6531443(None) 
lieges74113441lieges
lieve86315471lieve
siege66718441siege
allege74314652allege
beige81515382beige
bilge87618912bilge
binge85125512binge
diene65720132diene
dinge75627302dinge
dirge75117072dirge
fidge104516062fidge
hinge95323452hinge
large65325462large
ledge76519492ledge
lee36068142l_e_e
leg46446112l_eg_
leger65721512l_eger
leges64427292l_eges
legs56133692l_egs
leke85527402l_eke
liane54720662liane
lice66045062li_ce
lie38264522li__e
lied55838092lie_d
lieder74912322lieder
lief76036992lie_f
liefer9529572liefer
lien45339802lie_n
liens56525502liens
lier45942462lie_r
lierne638022lierne
liers55130402liers
lies46454192lie_s
lieu46534362lie_u
lieus56218482lieus
liever94611862liever
life75433732li_fe
liger65024472liger
like86040842li_ke
lime66244932li_me
linage7713402linage
line46965572li_ne
lineage878982lineage
ling57447962ling_
linga66820822linga
linger75226002linger
lingo66022112lingo
lings67135772lings
lingy96925142lingy
lipe66839732li_pe
lire47845292li_re
lisle53916722lisle
lite47054542li_te
lithe84922012lithe
litre55421462litre
live76540992li_ve
livre85613252livre
lodge76520092lodge
loge56837192l_oge
longe66626462longe
luge55531642l_uge
lunge65323802lunge
midge95016552midge
niece74814502niece
nieve85613182nieve
piece96717992piece
ridge75018672ridge
sieged85212712sieged
sieges73816832sieges
sieve84918842sieve
singe65731132singe
slieve9359272slieve
tinge64626622tinge

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit53800741.56334421.0
3Display Results74740.0135692.3
 (SQL Overall)178691741.88994595.6
 
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.