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

166 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
libation10241136(None) 
libations112510441libations
libration111510161libration
ligation92313091ligation
lobation102110551lobation
citation10314362citation
dilation92215462dilation
fixation1837072fixation
himation1339752himation
illation8311942illation
lavation1139972lavation
laxation1538422laxation
legation92412932legation
liberation1269992liberation
librations12149062librations
ligations102111992ligations
lineation9310762lineation
liquation1846552liquation
lobations11219612lobations
location102113912location
lunation8311922lunation
luxation1538232luxation
nidation9410582nidation
plication13311682plication
vibration14138202vibration
ablation10312433ablation
adnation9310783adnation
aeration8319933aeration
agitation10311223agitation
agnation9311723agnation
alation72920553_alation
alienation1048793alienation
ambition1246563ambition
animation11313683animation
aviation11312743aviation
basion84315853__basion
bastion9312473__bastion
baton75822423__bat_on
calibration1545993calibration
cation83925503__cation
ciliation111112493ciliation
citations11312503citations
clavation1447003clavation
conation101420883conation
creation102816513creation
delation92318083delation
diatron839283di_atron
dictation12810563dictation
diction102313053di_ction
dilations102614453dilations
dilution9239143dilution
donation91513783donation
dotation91412733dotation
duration9312693duration
elation73620453_elation
elevation1239233elevation
enation73419233_enation
epilation11312963epilation
equation17310483equation
fetation11613143fetation
fiction122010733fi_ction
filiation121110243filiation
fixations1936353fixations
flirtation1354823flirtation
flotation1267813flotation
foliation121110793foli_ation
gelation93014433gelation
gigaton946343gigat_on
gleization20115783gleization
gyration1237763gyration
halation11313853halation
himations1438803himations
ideation9310493ideation
illations9311393illations
imitation11510853imitation
inaction1039623_inaction
iodation9310383iodation
isatin6412213_isati_n
kation104315683__kation
lactation11310813lactation
lallation939493lallation
lamination12311223lamination
latino64120473l__atino
laudation1088133laudation
lavations1238973lavations
laxations1637623laxations
lection92614863l_ection
legations102711923legations
lenition8310083lenition
levigation1447023levigation
levitation1349443levitation
liaison744473li_aison
libationary1672163libationary
liberations1358943liberations
librarian1154843librarian
librating1239053librating
librational1344553librational
ligating102212283ligating
ligative1258803ligative
limacon1144143lima_con
limitation1249153limitation
lineations1039543lineations
liquations1945623liquations
literation10511413literation
litigation1148173litigation
lobulation1247233lobulation
locations112512743locations
locution10227663locution
lotion65716523l__otion
lunations9310723lunations
luxations1637273luxations
migration12179703migration
mutation101412883mutation
natation81513933natation
nation64322803__nation
negation92913023negation
nictation1189273nictation
nidations1039213nidations
nitration9313443nitration
notation81414603notation
novation111710013novation
nutation81513103nutation
oblation1039863oblation
obligation1346783obligation
oration71617713_oration
ovation101510023_ovation
oxidation1746323oxidation
pinnation1138013pinnation
placation1339773placation
planation11310123planation
plications14310493plications
potation101716783potation
prelibation15128663prelibation
privation14311173privation
probation13412183probation
pupation1269503pupation
ration64226013__ration
relation82619773relation
rogation91612053rogation
rotation81615453rotation
ruination9311273ruination
sabaton937713sabat_on
salivation1349813salivation
sedation9312453sedation
sibilation12128773sibilation
siltation939213siltation
sinuation9310413sinuation
situation949423situation
solation8916153solation
station72717243_station
sublation11311013sublation
sudation9310803sudation
taxation1537993taxation
titration9310543titration
ululation938093ululation
urination9312173urination
vacation131911893vacation
validation1448413validation
venation11513503venation
vexation1838783vexation
vibrations15157373vibrations
vibrion1245253vib_rion
violation1238443violation
vitiation1239563vitiation
vocation132311983vocation
zonation171410723zonation

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 Filter1786911461620.483369960.7
2DLD Change Limit1461621667.56319325.9
3Display Results1661660.0802075.0
 (SQL Overall)1786911668.12621990.0
 
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.