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

65 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
extorters164576(None) 
exhorters1944711exhorters
exporters1846251exporters
extorter1546511extorter_
exhorter1845352exhorter_
exporter1737362exporter_
extollers1663852extollers
extorted1636232extorte_d
extorts1447752extort__s
retorters938772retorters
aborters1038573_aborters
assorters965733assorters
cavorters1434973cavorters
deporters1277793deporters
distorters1147163distorters
emborders1444573emborders
emoters94712873e_mo_ters
endorsers1046123endorsers
enforcers14215213enforcers
enterers82214153enter_ers
estovers1136453esto_vers
exacters1736773ex_acters
exalters1536653ex_alters
excerpters2143183excerpters
exciters1736323ex_citers
excreters1874873excreters
executers1854183executers
exhorted1935013exhorte_d
exhorts1746313exhort__s
expecters2045473expecters
expirers1735123expir_ers
exploiters1943833exploiters
explorers1843743explor_ers
exported1837133exporte_d
exports1647983export__s
exposers1736133expo_sers
extenders17125673extenders
exteriors1647323exteriors
externes1539833externe_s
extoller1564183extoller_
extort13513973extort___
extorting1746763extorting
extortion1646723extortion
extortioners1952063extortioners
extortions1746473extortions
extortive1945143extortive
extrovert1955793extrovert
extroverts2072993extroverts
extruders1743403extruders
importers13247763importers
porters93722703__porters
reporters1139173reporters
resorters939693resorters
restorers95110113restor_ers
retorter8410733retorter_
snorters83410583_snorters
sorters74221133__sorters
sporters103714063_sporters
starters83714773_starters
storers75018683_stor_ers
tooters73818773__tooters
tortes64826053__torte_s
toters65026363__to_ters
totters74618733__totters
touters74018353__touters

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 Filter1786911486410.500357382.0
2DLD Change Limit148641656.92321470.6
3Display Results65650.0302166.7
 (SQL Overall)178691657.45323975.7
 
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.