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

149 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
arresting103863(None) 
arrestant947322arrestant
arrestingly1552962arrestingly
arrestive1246752arrestive
attesting1036382attesting
cresting114017042_cresting
foresting13311362foresting
harvesting1744412harvesting
priesting1239482priesting
rearresting1245962rearresting
reesting93118272_reesting
resting85031182__resting
unresting10311132unresting
wresting123811832_wresting
abetting1158293a_betting
abreacting1544533abreacting
absenting1236993absenting
accenting1487823accenting
accepting1695803accepting
accessing1445833accessing
accosting1446733accosting
accreting1446333accre_ting
addressing1343133addressing
adjusting1843833adjusting
advecting1645113advecting
adverting1437223adverting
aerating92821003aer_ating
affecting1845233affecting
afforesting1852853afforesting
agenting1039383a_genting
aggressing1344183aggressing
agisting1038243a_gisting
agreeing10295903agre_eing
agrestic1147923agresti_c
airting83616303air__ting
alerting91312383a_lerting
amnestying1642033amnestying
argentine1047893argentine
arising83619973a_ris_ing
arointing1049363arointing
arousing93811803arous_ing
aroynting1344633aroynting
arranging1156303arranging
arraying1238753arr_aying
arrest63722633arrest___
arrestants1044323arrestants
arrested939153arrest_ed
arrestee849443arrest_ee
arrestees946233arrestees
arrester839253arrest_er
arresters948193arresters
arrestment1246253arrestment
arrestor847653arrest_or
arrestors958033arrestors
arrests73312683arrest__s
arriving1237363arr_iving
arrogating121778393arrogating
arrowing1237943arr_owing
asbestine1144883asbestine
assenting1038163assenting
asserting1038663asserting
assessing1045173assessing
assisting1046183assisting
aureoling1045873aureoling
averting122512733a_verting
barreling1238043barre_ling
barrelling1345453barrelling
besting104923923__besting
breasting1239583breasting
bursting1138703bur_sting
caressing1238803caressing
carpeting1439483carpe_ting
correcting15199303correcting
corseting12312173corseting
creating113921953_creating
creeshing1536243creeshing
crestings12298043_crestings
crusting113612793_crusting
curetting1236573curetting
detesting112610323detesting
devesting14249903devesting
digesting12208673digesting
directing1338823directing
divesting14298483divesting
dressing102810423_dressing
egesting1039013_egesting
egressing1146853egressing
erecting112415063_erecting
ferreting13127693ferre_ting
freshing152611023_freshing
fretting122711523_fretting
frosting12311183_frosting
frowsting1634683frowsting
garmenting1445483garmenting
garroting1136953garr_oting
garrotting1254193garrotting
greeting103112353_greeting
guesting1058463_guesting
harnessing1443903harnessing
infesting13109513infesting
ingesting11129623ingesting
investing13119393investing
irrupting1243553irrupting
jesting154317713__jesting
laureating1146393laureating
margenting1446153margenting
marketing1636513marke_ting
molesting1237753molesting
narrating10310353narr_ating
nesting84320443__nesting
obtesting1245883obtesting
orienting1038723orienting
parenting12611583parenting
pargeting1338283parge_ting
pargetting1444943pargetting
parroting1239153parr_oting
pressing112516443_pressing
pretesting131810683pretesting
protesting131910253protesting
questing1838273_questing
rarefying1654693rarefying
renesting102514703renesting
renting84026853__renting
rerenting102617663rerenting
resiting93521123__resiting
restring91518783__restring
retesting102614603retesting
retting83425883__retting
revesting132814123revesting
riesling939013_riesling
roasting93012703_roasting
roosting93411463_roosting
rousting93913273_rousting
rusting83821263__rusting
stressing1038333stressing
targeting1137303targe_ting
testing86021053__testing
threating131010053threating
threshing1645663threshing
thrusting1335013thrusting
treating92519613_treating
trusting93411653_trusting
trysting12267053_trysting
vesting114618683__vesting
warranting1444743warranting
westing115020273__westing
worsting1267683wor_sting
wrestling1336063_wrestling
zesting174515333__zesting

Search took 9 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.453394461.4
2DLD Change Limit1486411497.46619909.1
3Display Results1491490.0801862.5
 (SQL Overall)1786911497.99922339.2
 
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.