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

107 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
locution1022766(None) 
elocution1145671elocution
location102113911location
locutions11207061locutions
allocution1244082allocution
elocutions1245962elocutions
lection92614862lec_tion
lobation102110552lobation
locations112512742locations
lotion65716522lo__tion
solution889592solution
vocation132311982vocation
volution1198602volution
ablution1047223ablution
action84719683_ac_tion
allocation1248573allocation
allocutions1353983allocutions
arcuation11410583arcuation
auction93412933auc_tion
avocation14168993avocation
bilocation1446123bilocation
bouton8311533bo_ut_on
cation83925503__cation
caution93013523_caution
coaction12310773coaction
coition9314313co_ition
conation101420883conation
cooption1288343cooption
cutin75022783__cuti_n
decurion1146623decurion
diction102313053dic_tion
dilution9239143dilution
donation91513783donation
dotation91412733dotation
eduction1169053eduction
election102015353elec_tion
elution72913823_elution
evocation142010293evocation
evolution12117093evolution
execution1846303execution
faction122613333fac_tion
fiction122010733fic_tion
flection13239563flec_tion
flotation1267813flotation
incaution1146583incaution
iodation9310383iodation
lactation11310813lactation
lavation1139973lavation
laxation1538423laxation
lectin82515013lec_ti_n
lections102413843lec_tions
legation92412933legation
lenition8310083lenition
libation102411363libation
ligation92313093ligation
liquation1846553liquation
lobations11219613lobations
lobulation1247233lobulation
locating11311503locating
locational1246593locational
locative1338683locative
locator93110423locat_or
locomotion1452593locomotion
loculi8288253loculi__
locutory1344273locutory
logion76013723lo__gion
lotions74614763lo__tions
louting83719383lo_uting
loutish1039963lo_utish
lunation8311923lunation
luxation1538233luxation
monition10311723monition
motion85217553mo__tion
mouton8410853mo_ut_on
nonunion845583nonunion
notation81414603notation
notion64516583no__tion
novation111710013novation
option83612713_o_ption
oration71617713_oration
ovation101510023_ovation
paction112713963pac_tion
placation1339773placation
plication13311683plication
pollution1146003pollution
portion9615493po_rtion
position10912193position
potation101716783potation
potion84519573po__tion
recaution1148093recaution
relocation12312113relocation
rogation91612053rogation
rotation81615453rotation
ruction93611613ruc_tion
section92515663sec_tion
solation8916153solation
solutions988883solutions
sorption1037513sorption
suction93713043suc_tion
taction93213023tac_tion
unction9310663unc_tion
vacation131911893vacation
vocations141911423vocations
volition1179173volition
volutin1098103voluti_n
volutions12108393volutions
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.483369960.7
2DLD Change Limit1461621077.23620199.3
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.76523012.4
 
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.