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

207 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
arriving123736(None) 
archiving1844762archiving
arising83619972a_rising
arraying1238752arraying
arrowing1237942arrowing
deriving132510742deriving
driving123910712_driving
reiving113316842_reiving
riving104521422__riving
scriving14258762scriving
shriving15268452shriving
striving122611392striving
thriving15246352thriving
abiding11510503a_biding
abrading1239503abrading
abridging1443853abridging
achieving1843303achieving
acridine1139553acridine
admiring1236133admiring
admixing1944133admixing
advising1336153advising
aerating92821003aerating
aerifying1636493aerifying
affixing2264333affixing
aggrieving1681483aggrieving
agnizing1936833agnizing
agreeing10295903agreeing
aiding84423613a__iding
ailing74331013a__iling
aiming94320843a__iming
airing74927503a__iring
airthing12297953airthing
airting83616303air_ting
alining81917043a_lining
antiking13412073antiking
anviling1239743anviling
apprising1447963apprising
apprizing2347193apprizing
approving1745053approving
aproning11311793aproning
arabizing2147963arabizing
arborizing2256643arborizing
arcading1239763arcading
arching136216693a_rching
arcing95819643a_r_cing
arcking145811963a_rcking
arginine948563arginine
argling92812733a_rgling
arguing9248733a_rguing
arming94719803a_r_ming
armoring1149123armoring
arointing1049363arointing
arousing93811803arousing
arraign845063arr_aign
arraigning1242783arraigning
arranging1156303arranging
arresting1038633arresting
arrival1037563arriv_al
arrivals1145933arrivals
arrive91311793arriv__e
arrived11127353arriv_ed
arriver10117793arriv_er
arrivers11137003arrivers
arrives101311513arriv_es
arriviste1242733arriviste
articling1247713articling
ascribing1444953ascribing
aspiring1138873aspiring
attiring939483attiring
attriting1048683attriting
auditing1039033auditing
availing1267283availing
avoiding1336783avoiding
awaiting1238273awaiting
barraging1337383barraging
barreling1238043barreling
barring104021593barr__ing
beriming13310463beriming
braiding123112703braiding
brailing113514793brailing
braining113414683braining
braising113014563braising
braving133714613_braving
bribing123111043_bribing
brining103216473_brining
broiling113112013broiling
bruising11279143bruising
bruiting11259973bruiting
caregiving1743143caregiving
carroming1437683carroming
carrying14148373carr_ying
carving133916773car_ving
codriving1645213codriving
craving134015733_craving
cruising112610153cruising
curving133912103cur_ving
depriving1636403depriving
deriding112512933deriding
diving113717953__diving
draining103312673draining
drivings13265763_drivings
droving12379683_droving
earring83519013earr__ing
erring73816483err__ing
farrowing1645873farrowing
forgiving1744343forgiving
frizing203310873_frizing
fruiting12229063fruiting
garring93116713garr__ing
garroting1136953garroting
giving114313883__giving
graining102813183graining
graving123114563_graving
griding103014973_griding
grieving1385893grieving
griming113612493_griming
griping113012063_griping
groining102310633groining
grooving13286713grooving
hagriding1544733hagriding
harrowing1646433harrowing
harrying15157643harr_ying
hiving134115523__hiving
irising83614423_irising
jarring153613193jarr__ing
jiving173711603__jiving
larrikin1243793larrikin_
larrikins1343793larrikins
larruping1243243larruping
lawgiving1762143lawgiving
living104318323__living
margining1337603margining
marring103319553marr__ing
marrowing1546663marrowing
marrying14157223marr_ying
meriting11314683meriting
motiving1437163motiving
narrating10310353narrating
narrowing1345603narrowing
nerving112910823ner_ving
orbiting1138153orbiting
parring103222063parr__ing
parroting1239153parroting
parrying14168133parr_ying
periling11316863periling
praising113214563praising
pricing123417343_pricing
priding113317543_priding
priming123417373_priming
prising103321453_prising
prizing193514683_prizing
proving134214073_proving
radioing1039383radioing
raiding93617593_raiding
railing83325643_railing
raining83922693_raining
raising83220533_raising
rarifying1646313rarifying
raring74332873rar__ing
raving105128853__raving
ravining12269693ravining
reaving113820533_reaving
redriving1437603redriving
reeving113717663_reeving
regiving13269713regiving
reining84425323_reining
reliving122713343reliving
rerising93017783rerising
reviving152910503reviving
revving14379343_revving
ricing94822763__ricing
riding84325963__riding
riling74227973__riling
riming93322223__riming
riping93821613__riping
rising74025883__rising
roiling83220453_roiling
roving103618743__roving
ruining83514883_ruining
sardining1137573sardining
scribing13238183scribing
scrieving1534133scrieving
serving113014983ser_ving
shrieving1633973shrieving
shrining122610853shrining
skiving15298373_skiving
striding102713603striding
striking133012233striking
striping112612523striping
surviving1644163surviving
swiving14358953_swiving
tarring83318303tarr__ing
tarrying12146723tarr_ying
traiking132511973traiking
trailing92916093trailing
training93015863training
tricing103417353_tricing
trining82919213_trining
ungiving1346333ungiving
unliving1248193unliving
updiving1534223updiving
uprising1138953uprising
waiving14329633_waiving
warring113717973warr__ing
wiving133316603__wiving
worriting1345553worriting
writing113713893_writing

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.1561145455.1
2DLD Change Limit1461622077.33019940.2
3Display Results2072070.0762723.7
 (SQL Overall)1786912077.56223630.1
 
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.