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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

125 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
librating123905(None) 
liberating1349251liberating
vibrating1537471vibrating
calibrating1645342calibrating
disrating11714552disrating
libration111510162libration
librations12149062librations
ligating102212282li_gating
liquating1946312liquating
migrating13910532migrating
misrating121014852misrating
nitrating10312672nitrating
pirating11314512pi_rating
titrating10310112titrating
abating10413973_ab_ating
ablating11311993_ablating
abrading1239503_abrading
acierating1348313acierating
aerating92821003_aerating
airting83616303ai_r_ting
alienating1147223alienating
bating95132253__b_ating
beating104326873__beating
berating113220763_berating
boating103721303__boating
borating113414503_borating
bracing123817613__bracing
braking143917713__braking
braving133714613__braving
braying134416313__braying
brazing193715113__brazing
bruting102612993__bruting
celebrating1646113celebrating
crating103725203__crating
curating11314293_curating
debating123213733deb_ating
deliberating1645123deliberating
derating103222283_derating
dictating1338883dictating
dilating102714903di_lating
elaborating1444863elaborating
embracing1645443embracing
embruting1444283embruting
emigrating1467503emigrating
filiating1339243filiating
filtrating1445973filtrating
fixating1936183fi_xating
flirting12319013fli_r_ting
gibbeting1542903gibbeting
girting93113333gi_r_ting
grating93923183__grating
gyrating1337453_gyrating
hibernating1753173hibernating
hydrating1746323hydrating
ideating10311703_ideating
imbruting1443773imbruting
iodating1038823_iodating
iterating10314253iterating
lacerating1349443lacerating
lactating1239183lactating
lariating10311783lariating
laureating1146393laureating
legating102313113l_egating
libation102411363lib_ation
libations112510443lib_ations
libeling1139873lib_eling
libelling1236873libelling
liberation1269993liberation
liberations1358943liberations
libertine1147433libertine
librarian1154843librarian
librarians1263953librarians
libraries1146993libraries
librate93214233librat__e
librated113110313librat_ed
librates103412953librat_es
librational1344553librational
libratory14255803libratory
lichting14268513li_chting
lifting113313273li__fting
lighting132811833li_ghting
lilting83515383li__lting
limiting1138813li_miting
linting83820983li__nting
lipreading1444043lipreading
listing84020593li__sting
litigating1246743litigating
locating11311503l_ocating
lubricating1644713lubricating
lucubrating1652783lucubrating
lustrating1147783lustrating
luxating1645613l_uxating
meliorating1446563meliorating
misdating131010663misdating
miseating121215433miseating
mismating141211823mismating
narrating10310353narrating
nictating1237573nictating
nidating1039783ni_dating
operating12313723operating
orating83520323__orating
outrating10916403outrating
prating103424453__prating
prorating12314283prorating
rating74938703___rating
rebating112418343reb_ating
recrating121318793recrating
regrating111316213regrating
revibrating1745573revibrating
serrating10513203serrating
sibilating1346963sibilating
sinuating1039683sinuating
situating1038883situating
sublating12310983sublating
ulcerating1346983ulcerating
unbracing1437023unbracing
unbraking1636933unbraking
uncrating12813183uncrating
uprating11311113_uprating
vibratile1443663vibratile
vibration14138203vibration
vibrations15157373vibrations
vibrative1745583vibrative
violating1337433violating
vitiating1338403vitiating

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.1731032896.0
2DLD Change Limit1486411257.40620070.3
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.62523434.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.