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

113 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
libration11151016(None) 
libation102411361lib_ation
liberation1269991liberation
librations12149061librations
vibration14138201vibration
calibration1545992calibration
libations112510442lib_ations
liberations1358942liberations
librarian1154842librarian
librating1239052librating
librational1344552librational
ligation92313092li_gation
lineation9310762lineation
liquation1846552liquation
literation10511412literation
lobation102110552lob_ation
migration12179702migration
nitration9313442nitration
titration9310542titration
vibrations15157372vibrations
ablation10312433_ablation
abrasion1046623_abrasion
adoration10311313adoration
aeration8319933_aeration
alienation1048793alienation
alteration10612903alteration
calibrations1645153calibrations
celebration1546463celebration
ciliation111112493ciliation
citation10314363ci_tation
deliberation1546363deliberation
dictation12810563dictation
dilation92215463di_lation
duration9312693_duration
elaboration1345743elaboration
emigration13228213emigration
figuration1445913figuration
filiation121110243filiation
filtration1346433filtration
fimbriation1843553fimbriation
fixation1837073fi_xation
flirtation1354823flirtation
gyration1237763_gyration
hibernation1644093hibernation
himation1339753hi_mation
hydration1646073hydration
ideation9310493_ideation
illation8311943_illation
iodation9310383_iodation
iteration9515033iteration
laceration1249573laceration
lactation11310813lactation
lallation939493lallation
laudation1088133laudation
laureation1046153laureation
lavation1139973l_avation
laxation1538423l_axation
legation92412933l_egation
liberating1349253liberating
liberator1147063liberat_or
librarians1263953librarians
libraries1146993libraries
librate93214233librat__e
librated113110313librat_ed
librates103412953librat_es
libratory14255803libratory
libretto1043703libretto_
librettos1153593librettos
ligations102111993li_gations
limitation1249153limitation
lineations1039543lineations
liquations1945623liquations
literations11610583literations
litigation1148173litigation
lobations11219613lob_ations
lobulation1247233lobulation
location102113913l_ocation
lubrication1546343lubrication
lucubration1553003lucubration
lunation8311923l_unation
lustration1048353lustration
luxation1538233l_uxation
melioration1368183melioration
migrations13168683migrations
narration9310063narration
nictation1189273nictation
nidation9410583ni_dation
nitrations10312033nitrations
oblation1039863_oblation
operation11314003operation
oration71617713__oration
pinnation1138013pinnation
plication13311683pli_cation
proration11415983proration
ration64226013___ration
serration9414063serration
sibilation12128773sibilation
siltation939213siltation
sinuation9310413sinuation
situation949423situation
sublation11311013sublation
titrations1039173titrations
ulceration1247263ulceration
vibratile1443663vibratile
vibrating1537473vibrating
vibrational1644363vibrational
vibrative1745583vibrative
vibrato12247383vibrat_o_
vibrator13227343vibrat_or
vibratos13217483vibrat_os
vibrion1245253vibr__ion
violation1238443violation
vitiation1239563vitiation

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411136.11024327.5
3Display Results1131130.0462456.5
 (SQL Overall)1786911136.57927160.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.