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

95 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
vibration1413820(None) 
libration111510161libration
vibrations15157371vibrations
libation102411362lib_ation
liberation1269992liberation
librations12149062librations
migration12179702migration
nitration9313442nitration
titration9310542titration
vibratile1443662vibratile
vibrating1537472vibrating
vibrational1644362vibrational
vibrative1745582vibrative
vibrato12247382vibrat_o_
vibrator13227342vibrat_or
vibratos13217482vibrat_os
vibrion1245252vibr__ion
violation1238442violation
vitiation1239562vitiation
ablation10312433_ablation
abrasion1046623_abrasion
adoration10311313adoration
aeration8319933_aeration
aviation11312743avi__ation
calibration1545993calibration
ciliation111112493ciliation
citation10314363ci_tation
dictation12810563dictation
dilation92215463di_lation
duration9312693_duration
emigration13228213emigration
figuration1445913figuration
filiation121110243filiation
filtration1346433filtration
fimbriation1843553fimbriation
fixation1837073fi_xation
gyration1237763_gyration
hibernation1644093hibernation
himation1339753hi_mation
hydration1646073hydration
ideation9310493_ideation
illation8311943_illation
iodation9310383_iodation
iteration9515033iteration
libations112510443lib_ations
liberations1358943liberations
librarian1154843librarian
librating1239053librating
librational1344553librational
ligation92313093li_gation
lineation9310763lineation
liquation1846553liquation
literation10511413literation
lobation102110553lob_ation
migrations13168683migrations
narration9310063narration
nictation1189273nictation
nidation9410583ni_dation
nitrations10312033nitrations
oblation1039863_oblation
operation11314003operation
oration71617713__oration
pinnation1138013pinnation
proration11415983proration
ration64226013___ration
serration9414063serration
sibilation12128773sibilation
siltation939213siltation
sinuation9310413sinuation
situation949423situation
sublation11311013sublation
titrations1039173titrations
vacation131911893v_acation
vallation1239743vallation
valuation1249973valuation
variation12312393variation
venation11513503v_enation
veneration13412343veneration
vernation12311083vernation
vexation1838783v_exation
vibraphone2051823vibraphone
vibrate122811523vibrat__e
vibrated14228393vibrat_ed
vibrates132210613vibrat_es
vibrators14237253vibrators
vibratory17235563vibratory
vibrio1136223vibr__io_
vibrions1345093vibr__ions
vibrios1235803vibr__ios
violations1337963violations
virion9310683vi_r__ion
visitation1348593visitation
vitiations1338743vitiations
vitrain1038943vitra_i_n
vocation132311983v_ocation

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.423422437.4
2DLD Change Limit148641956.98321286.1
3Display Results95950.0462065.2
 (SQL Overall)178691957.45223978.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.