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

98 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
ablution104722(None) 
ablation10312431ablation
ablutions1146601ablutions
abduction14125412abduction
ablations11311512ablations
abolition1147052abolition
abortion1048102abortion
abruption1343972abruption
absolution1244402absolution
abutilon1043082ab_utilon
alation72920552a_lation
allusion846572allusion
alluvion1144732alluvion
dilution9239142dilution
elution72913822_elution
oblation1039862oblation
solution889592solution
volution1198602volution
abductions15125383abductions
abjection2045323abjection
abjuration1945883abjuration
ablating11312003ablating
ablative1348243ablative
ablator939843ablat_or
abluted10188363ablut_ed
ablutionary1652273ablutionary
abolitions1246653abolitions
abortions1147783abortions
abrasion1046623abrasion
abruptions1443843abruptions
absolutions1344713absolutions
abutilons1142963ab_utilons
action84719683a__ction
actuation11310333actuation
acylation1448653acylation
adaption1145643adaption
addition1096893addition
adduction13225163adduction
adnation9310783adnation
adoption1146083adoption
adulation10311013adulation
aeration8319933aeration
affusion1443923affusion
agnation9311723agnation
alations82518893a_lations
albumin1145563albumi_n
allocution1244083allocution
allusions946013allusions
alluvions1254373alluvions
alumin8513543a_lumi_n
ambition1246563ambition
ambulation1447873ambulation
amotion9710473a_motion
arcuation11410583arcuation
auction93412933a_uction
audition979173audition
aviation11312743aviation
avulsion1153863avulsion
bastion9312473_bastion
bouton8311533_bout_on
bullion91911033_bullion
bunion83111313_b_union
button8310273_b_utton
calutron1045553calutron
caution93013523_caution
delation92318083delation
deletion92011973deletion
delusion937433delusion
dilation92215463dilation
dilutions10248583dilutions
diluvion12215413diluvion
elation73620453_elation
elusion72310953_elusion
elutions82513053_elutions
evolution12117093evolution
fluxion1735043_fluxion
gelation93014433gelation
glutton844893_glutton
halation11313853halation
illation8311943illation
illusion846573illusion
lallation939493lallation
locution10227663locution
lotion65716523__lotion
oblations1139373oblations
oblivion1343643oblivion
pluton838853_plut_on
pollution1146003pollution
relation82619773relation
solation8916153solation
solutions988883solutions
sublation11311013sublation
tabulation1247813tabulation
vallation1239753vallation
valuation1249973valuation
volition1179173volition
volutin1098103voluti_n
volutions12108393volutions

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 Filter1786911461620.420425454.8
2DLD Change Limit146162987.34319904.9
3Display Results98980.0332969.7
 (SQL Overall)178691987.79622920.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.