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

165 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
libations11251044(None) 
libation102411361libation_
librations12149061librations
ligations102111991ligations
lobations11219611lobations
citations11312502citations
dilations102614452dilations
fixations1936352fixations
himations1438802himations
illations9311392illations
lavations1238972lavations
laxations1637622laxations
legations102711922legations
liberations1358942liberations
libration111510162libration_
ligation92313092ligation_
lineations1039542lineations
liquations1945622liquations
lobation102110552lobation_
locations112512742locations
lunations9310722lunations
luxations1637272luxations
nidations1039212nidations
plications14310492plications
vibrations15157372vibrations
ablations11311513ablations
adnations1039753adnations
aerations9317903aerations
agitations11310063agitations
agnations10310033agnations
alations82518893_alations
alienations1147883alienations
ambitions1346343ambitions
animations12312193animations
aviations12311553aviations
basions94213953__basions
bastions10411693__bastions
batons85519423__bat_ons
calibrations1645153calibrations
cations94524143__cations
ciliations121111003ciliations
citation10314363citation_
clavations1546183clavations
conations111318903conations
creations112614543creations
delations102616593delations
diatrons939613di_atrons
dictations1389703dictations
dictions111812673di_ctions
dilation92215463dilation_
dilutions10248583dilutions
donations101112353donations
dotations101411633dotations
durations10311463durations
elations83719123_elations
elevations1338633elevations
enations83316903_enations
epilations12311713epilations
equations1839493equations
fetations12511383fetations
fictions132410743fi_ctions
filiations13119093filiations
fixation1837073fixation_
flirtations14104263flirtations
flotations1366873flotations
foliations1399943foli_ations
gelations102513093gelations
gigatons1046053gigat_ons
gleizations21135283gleizations
gyrations1336923gyrations
halations12312393halations
himation1339753himation_
ideations1039903ideations
illation8311943illation_
imitations1259963imitations
inactions1139323_inactions
iodations1039113iodations
isatins7310773_isati_ns
kations114013663__kations
lactations1239423lactations
lallations1038743lallations
laminations1339803laminations
latinos73613803l__atinos
laudations1146843laudations
lavation1139973lavation_
laxation1538423laxation_
lections102413843l_ections
legation92412933legation_
lenitions939473lenitions
levigations1546213levigations
levitations1448293levitations
liaisons844293li_aisons
libationary1672163libationary
liberation1269993liberation_
librarians1263953librarians
librating1239053librati_ng
librational1344553librational
ligating102212283ligati_ng
limacons1243953lima_cons
limitations1348183limitations
lineation9310763lineation_
liquation1846553liquation_
literations11610583literations
litigations1247333litigations
lobulations1346213lobulations
location102113913location_
locutions11207063locutions
lotions74614763l__otions
lunation8311923lunation_
luxation1538233luxation_
migrations13168683migrations
mutations111211453mutations
natations91412493natations
nations74720563__nations
negations102811963negations
nictations1278313nictations
nidation9410583nidation_
nitrations10312033nitrations
notations91512973notations
novations12139003novations
nutations91411763nutations
oblations1139373oblations
obligations1446143obligations
orations81515803_orations
ovations11149263_ovations
oxidations1845443oxidations
pinnations1236883pinnations
placations1438583placations
planations1238723planations
plication13311683plication_
potations111615073potations
prelibations16127623prelibations
privations15310103privations
probations14311083probations
pupations1338123pupations
rations74123433__rations
relations92418333relations
rogations101510823rogations
rotations91613843rotations
ruinations1039603ruinations
sabatons1037843sabat_ons
salivations1448733salivations
sedations10311253sedations
sibilations13127933sibilations
siltations1038553siltations
sinuations1039413sinuations
situations1038433situations
solations9814623solations
stations82415223_stations
sublations12410113sublations
sudations1039903sudations
taxations1636863taxations
titrations1039173titrations
ululations1037143ululations
urinations10310693urinations
vacations141910553vacations
validations1547243validations
venations12311723venations
vexations1937753vexations
vibration14138203vibration_
vibrions1345093vib_rions
violations1337963violations
vitiations1338743vitiations
vocations141911423vocations
zonations18139313zonations

Search took 9 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.420425454.8
2DLD Change Limit1486411657.58019609.6
3Display Results1651650.0762171.1
 (SQL Overall)1786911658.07622126.2
 
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.