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

119 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
volution119860(None) 
evolution12117091evolution
solution889591solution
volition1179171volition
volutin1098101voluti_n
volutions12108391volutions
ablution1047222ablution
devolution1486282devolution
dilution9239142dilution
elution72913822_elution
evolutions13107042evolutions
involution1345942involution
locution10227662locution
pollution1146002pollution
revolution13117562revolution
solation8916152solation
solutions988882solutions
valuation1249972valuation
violation1238442violation
vocation132311982vocation
volitions1288662volitions
volutins1188002volutins
ablation10312433ablation
ablutions1146593ablutions
abolition1147053abolition
absolution1244403absolution
alation72920553_alation
allusion846573allusion
alluvion1144733alluvion
avocation14168993avocation
bolection13117673bolection
bouton8311533bo_ut_on
calutron1045553calutron
caution93013523_caution
coaction12310773coaction
coalition1148703coalition
coevolution1654223coevolution
coition9314313co_ition
collation11313993collation
collusion1146413collusion
conation101420883conation
convolution1645123convolution
cooption1288343cooption
delation92318083delation
deletion92011973deletion
delusion937433delusion
devolutions15106263devolutions
dilation92215463dilation
dilutions10248583dilutions
diluvion12215413diluvion
donation91513783donation
dotation91412733dotation
elation73620453_elation
elocution1145673elocution
elusion72310953_elusion
elutions82513053_elutions
evaluation1358183evaluation
evocation142010293evocation
exsolution1743763exsolution
fluxion1735043_fluxion
foliation121110793foliation
gelation93014433gelation
glutton844893_glutton
halation11313853halation
illation8311943illation
illusion846573illusion
involutions1445903involutions
iodation9310383iodation
isolation9311643isolation
lobation102110553lobation
location102113913location
locutions11207063locutions
lotion65716523__lotion
monition10311723monition
motion85217553mo__tion
mouton8410853mo_ut_on
nonunion845583nonunion
notation81414603notation
notion64516583no__tion
novation111710013novation
oblation1039863oblation
option83612713_o_ption
oration71617713_oration
ovation101510023_ovation
ovulation1238983ovulation
pluton838853_plut_on
pollutions1245433pollutions
portion9615493po_rtion
position10912193position
potation101716783potation
potion84519573po__tion
prolusion1146363prolusion
relation82619773relation
resolution1097733resolution
revolutions1497633revolutions
rogation91612053rogation
rotation81615453rotation
solations9814623solations
solion6616383sol__ion
soliton7410233solit_on
solvation1237773solvation
sorption1037513sorption
vacation131911893vacation
vallation1239743vallation
valuations1348783valuations
venation11513503venation
vexation1838783vexation
violations1337963violations
vocations141911423vocations
volatile1146433volatile
volitional1345413volitional
volitive1446893volitive
volti84915963vol_ti__
voluming1435043voluming
volute93912763volut__e
voluted11297943volut_ed
volutes102710983volut_es
voudon1035873vo_u_don
zonation171410723zonation

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.1561145455.1
2DLD Change Limit1461621197.15620425.1
3Display Results1191190.0462587.0
 (SQL Overall)1786911197.35824285.3
 
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.