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

115 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
extoll133486(None) 
extol1247891exto_l
extolls1444601extolls
extols1337681extols
atoll57913922_atoll
enroll61110072enroll
entoil6912492entoil
extolled1654302extolled
extoller1564172extoller
extort13513972extort
toll45535262__toll
atolls65511353_atolls
bedroll1055553bedroll
boll65634753__boll
citola838393citola
citole8311503citole
dextral1577003dextral
doll56632493__doll
droll65415403_droll
eidola737683eidola
ell36735683e___ll
emboli1037473emboli
emboly1336713emboly
enfold10137613enfold
enol45823823e_no_l
enols54718403e_nols
enrol51014283enro_l
enrolls7108093enrolls
enrols61213383enrols
ensoul638253ensoul
entail61114343entail
entoils7810733entoils
entomb1037363entomb
estop74312103esto_p
estops84011223estops
estral64716513estral
ethyl1136513e_thyl
etoile6312263e_toile
exalt123018533ex_alt
excel1437743ex_cel
excels1536663excels
exhale1636873exhale
exhort16410803exhort
exile126117653ex_ile
exon117116803ex_o_n
exons125813343ex_ons
exotic153112643exotic
expel1448233ex_pel
expels1547173expels
expo1349183expo__
export15412183export
expos1449203expo_s
exposal1645313exposal
expose1549523expose
extant132714753extant
extend14267523extend
extent132714913extent
extern1348473extern
extollers1663843extollers
extolling1744623extolling
extorts1447753extorts
extra1239003ext_ra
extras13310223extras
exult122814123ex_ult
ixtle12168013ixt_le
ketol95414003keto_l
ketols104210763ketols
knoll9389603_knoll
loll46128383__loll
metol75917813meto_l
metols84115773metols
moll66735703__moll
outpoll946793outpoll
outroll749303outroll
oxtail1337653oxtail
poll66332133__poll
quoll14379493_quoll
redpoll1045043redpoll
repoll8410793repoll
reroll6412683reroll
retell63813643retell
retold73013753retold
retool63914483retool
roll46331653__roll
scroll8310163scroll
sextile1438573sextile
sexto124415453sexto__
sexton133610793sexto_n
sextons143710413sextons
sextos134012163sexto_s
sotol54917643soto_l
sotols63714453sotols
stall54722353_stall
still54922073_still
stole54928813_stole
stool55619893_stool
stroll6311603stroll
stull54916273_stull
tall47240213__tall
tell44934703__tell
textile1437223textile
textual1444603textual
till45941203__till
toil46536283__toil
tola45236333__tola
told56132203__told
tole46052903__tole
tolls54728433__tolls
tolu45529153__tolu
tolyl84710093__tolyl
tool46735683__tool
troll54416533_troll
unroll61210073unroll
untold7149683untold
xylol1546133_xylol

Search took 6 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 Filter1786911127160.1231452772.4
2DLD Change Limit1127161155.39320900.4
3Display Results1151150.0303833.3
 (SQL Overall)1786911155.54632219.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.