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

142 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
solution88959(None) 
solation8916151solation
solutions988881solutions
volution1198601volution
ablution1047222ablution
absolution1244402absolution
dilution9239142dilution
elution72913822_elution
evolution12117092evolution
exsolution1743762exsolution
isolation9311642isolation
locution10227662locution
pollution1146002pollution
resolution1097732resolution
solations9814622solations
solion6616382sol__ion
soliton7410232solit_on
solvation1237772solvation
sorption1037512sorption
volition1179172volition
volutin1098102voluti_n
volutions12108392volutions
ablation10312433ablation
ablutions1146603ablutions
abolition1147053abolition
absolutions1344713absolutions
alation72920553_alation
allusion846573allusion
alluvion1144733alluvion
bolection13117673bolection
bouton8311533bo_ut_on
calutron1045553calutron
caution93013523_caution
coaction12310773coaction
coalition1148703coalition
coition9314313co_ition
collation11313993collation
collusion1146413collusion
conation101420883conation
cooption1288343cooption
delation92318083delation
deletion92011973deletion
delusion937433delusion
desolation11311403desolation
devolution1486283devolution
dilation92215463dilation
dilutions10248583dilutions
diluvion12215413diluvion
dissolution12145023dissolution
donation91513783donation
dotation91412733dotation
elation73620453_elation
elocution1145673elocution
elusion72310953_elusion
elutions82513053_elutions
evolutions13107043evolutions
exsolutions1844013exsolutions
fluxion1735043_fluxion
foliation121110793foliation
gelation93014433gelation
glutton844893_glutton
halation11313853halation
illation8311943illation
illusion846573illusion
insolation10410213insolation
involution1345943involution
iodation9310383iodation
isolations10310693isolations
lobation102110553lobation
location102113913location
locutions11207063locutions
lotion65716523__lotion
monition10311723monition
motion85217553mo__tion
mouton8410853mo_ut_on
nonsolution1154743nonsolution
nonunion845583nonunion
notation81414603notation
notion64516583no__tion
novation111710013novation
oblation1039863oblation
option83612713_o_ption
oration71617713_oration
ovation101510023_ovation
pluton838853_plut_on
pollutions1245433pollutions
portion9615493po_rtion
position10912193position
potation101716783potation
potion84519573po__tion
prolusion1146363prolusion
relation82619773relation
resolutions11117793resolutions
revolution13117563revolution
rogation91612053rogation
rotation81615453rotation
saltation9312003saltation
salutation1048903salutation
saluting9310553saluting
salvation1239293salvation
sanction1049533sanction
scalation11311073scalation
scullion1065633scullion
seclusion1144943seclusion
section92515663s_ection
sedation9312453sedation
sedition939333sedition
seduction1266983seduction
selection11311273selection
siltation939213siltation
silurian846293silurian
sinuation9310413sinuation
situation949423situation
solanin7311943solani_n
solatia7312253solati_a
solating9315593solating
solatium1067613solatium
solions7513753sol__ions
solitons849593solit_ons
solon55026133sol___on
solstice1047223solstice
solute64016663solut__e
solutes73515263solut_es
solvations1336833solvations
sorptions1137123sorptions
sortition946703sortition
soupcon1144163so_upcon
southron1145493so_uthron
spoliation1248423spoliation
station72717243s_tation
stiction1038823stiction
sublation11311013sublation
suction93713043s_uction
sudation9310803sudation
sulcation11710733sulcation
sulfation1288783sulfation
valuation1249973valuation
violation1238443violation
vocation132311983vocation
volitions1288663volitions
volutins1188003volutins
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.420425454.8
2DLD Change Limit1461621426.62622058.9
3Display Results1421420.0632254.0
 (SQL Overall)1786911427.10925135.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.