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

86 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
liberating134925(None) 
librating1239051lib_rating
berating113220762__berating
deliberating1645122deliberating
hibernating1753172hibernating
iterating10314252_iterating
lacerating1349452lacerating
liberation1269992liberation
liberations1358942liberations
libertine1147432liber_tine
vibrating1537482vib_rating
acierating1348323acierating
aerating92821003__aerating
alienating1147233ali_enating
alliterating1354273alliterating
asperating1349563asperating
beating104326873__be_ating
beraking153612973__beraking
borating113414503__borating
calibrating1645353calib_rating
cybernating1952853cybernating
deaerating12311563deaerating
derating103222283__derating
disrating11714553di_srating
diverting142410333diver_ting
elaborating1444863elaborating
exuberating2144173exuberating
federating1548853federating
fiberizing2545053fiberizing
filtrating1445973filtrating
generating12310383generating
hebetating1645793hebetating
ideating10311703_ide_ating
itinerating1245233itinerating
lateraling11148803lateraling
laureating1146393laureating
legating102313113l__egating
leveraging1543793leveraging
libeling1139873libe__ling
libelling1236873libe_lling
liberalise1247593liberalise
liberalising1564123liberalising
liberalism1447043liberalism
liberalist1249063liberalist
liberality1545903liberality
liberalize2146953liberalize
liberalizing2455183liberalizing
liberate101113383liberat__e
liberated1299473liberat_ed
liberates111012943liberat_es
liberator1147063liberat_or
liberators1247013liberators
liberties1149203liber_ties
libertinage1451193liber_tinage
libertines1246533liber_tines
libration111510163lib_ration
librations12149063lib_rations
lifesaving1741793lifesaving
ligating102212283li__gating
limbering1488793limber__ing
linecasting14102783linecasting
lipreading1444043lipreading
liquating1946313li_quating
literati81210803literati__
literatim11127183literati_m
literation10511413literation
literations11610583literations
litigating1246743litigating
livering122012383liver__ing
lustrating1147783lustrating
macerating1549543macerating
migrating13910533mi_grating
miseating121215433mise_ating
misrating121014853mi_srating
moderating1448803moderating
nitrating10312673ni_trating
numerating1357233numerating
obliterating1553393obliterating
operating12313723_operating
pirating11314513pi__rating
reiterating12410493reiterating
sibilating1346973sibilating
titrating10310113ti_trating
tolerating1148593tolerating
ulcerating1346983ulcerating
venerating14410053venerating

Search took 7 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 Filter1786911406030.436409841.7
2DLD Change Limit140603865.89023871.5
3Display Results86860.0332606.1
 (SQL Overall)178691866.35928100.5
 
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.