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

97 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
extolls144460(None) 
extoll1334861extoll_
extols1337681exto_ls
atolls65511352_atolls
enrolls7108092enrolls
entoils7810732entoils
extol1247892exto_l_
extolled1654312extolled
extoller1564182extoller
extollers1663852extollers
extorts1447752extorts
tolls54728432__tolls
atoll57913923_atoll_
bedrolls1144673bedrolls
bolls75531313__bolls
citolas939363citolas
citoles9312553citoles
dolls66126923__dolls
drolls75312393_drolls
ells46431353e___lls
embolus1135543embolus
enfolds11136253enfolds
enols54718403e_no_ls
enroll61110073enroll_
enrols61213383enro_ls
ensouls736033ensouls
entails7912823entails
entellus845173entellus
entoil6912493entoil_
entombs1135613entombs
estops84011223esto_ps
ethyls1235903e_thyls
etoile6312263e_toile
etoiles7411293e_toiles
exalts13328313ex_alts
excels1536663ex_cels
exhales1737143exhales
exhorts1746313exhorts
exiles134816403ex_iles
exodos1435943ex_odos
exodus1434653ex_odus
exons125813343ex_o_ns
exotics16229193exotics
expels1547173ex_pels
exports1647983exports
expos1449203expo__s
exposals1744053exposals
exposes1639963exposes
extends15227113extends
extents142610173extents
externs1438233externs
extolling1744623extolling
extort13513973exto_rt
extras13310223ext_ras
exults13257633ex_ults
ixtles13217063ixt_les
ketols104210763keto_ls
knolls10367413_knolls
lolls512121733__lolls
metols84115773meto_ls
molls75129783__molls
outpolls1046213outpolls
outrolls847823outrolls
oxtails1436383oxtails
polls74627723__polls
quolls15327303_quolls
redpolls1144013redpolls
repolls939053repolls
rerolls739943rerolls
retells73211523retells
retools73411023retools
rolls55326233__rolls
scrolls938063scrolls
sextiles1537643sextiles
sextons143710413sexto_ns
sextos134012163sexto__s
sotols63714473soto_ls
stalls64019933_stalls
stills64118573_stills
stoles63927673_stoles
stools65117023_stools
strolls739183strolls
stulls63912983_stulls
talls55133433__talls
tells55828943__tells
textiles1536833textiles
tills54631713__tills
toils54527493__toils
tolas54532773__tolas
toles55147133__toles
toll45535263__toll_
tolus55024483__tolus
tolyls9436963__tolyls
tools55325243__tools
trolls64613943_trolls
unrolls797793unrolls
xylols1634173_xylols

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 Filter1786911340270.390458182.1
2DLD Change Limit134027977.06318975.9
3Display Results97970.0303233.3
 (SQL Overall)178691977.48323879.6
 
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.