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

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
liberties114920(None) 
libertines1246531libertines
liberates111012942liberates
libertine1147432libertine
liveries11314372liver_ies
puberties1346602puberties
albertites1244873albertites
amberies122514683amber_ies
berries94423553__berries
bibberies1297133bibber_ies
bilberries1444943bilberries
briberies1348333briber_ies
dirties83119383di__rties
fiberizes2346173fiberizes
fineries112416743finer_ies
inertias8410383_inertias
interties9320333interties
laborites1149263laborites
lacertids1244153lacertids
laterites9715063laterites
lefties10312073l__efties
legerities1196883legerities
libeccios1551613libeccios
libelees10227213libe_lees
libellees11274983libellees
liberalise1247593liberalise
liberalises1346833liberalises
liberalities1446263liberalities
liberalizes2246423liberalizes
liberals1039413liber_als
liberate101113383liberate_
liberated1299473liberated
liberating1349253liberating
liberation1269993liberation
liberations1358943liberations
liberators1247013liberators
libers84721443liber___s
libertinages1551153libertinages
libertinism1553013libertinism
liberty1237163libert__y
libraries1146993libraries
librates103412953lib_rates
librettos1153593librettos
liernes739623li_er_nes
lifetimes1444153life_times
linearities1146803linearities
lingberries1452823lingberries
lingeries10511813linger_ies
literacies1248803literacies
literates91415653literates
liturgies1043483liturgies
liveried1238733liver_ied
miseries10320403miser_ies
niceties10310863nice_ties
nineties8312913nine_ties
niteries8318383niter_ies
pieties9419223pi_e_ties
pineries102419083piner_ies
poverties1439513poverties
siderites10410433siderites
ubieties1046913ubie_ties
vineries112716043viner_ies
wineries112316533winer_ies

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 Filter1786911486410.436409841.7
2DLD Change Limit148641636.53322752.3
3Display Results63630.0302100.0
 (SQL Overall)178691636.99925530.9
 
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.