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

111 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
sweltry133341(None) 
peltry11288652_peltry
sentry92912052s_entry
shelty124011552shelt_y
smeltery13274962smeltery
sultry938462s_ultry
sweaty123710052sweat_y
sweetly1335592sweetly
swelter103711172swelter
swelters113110192swelters
agentry11165753agentry
aweary1237303awe_ary
belfry1435073_belfry
celery1139623_celery
dwelt94316523dwelt__
entry82414263__entry
gentry103410443_gentry
helotry1345653_helotry
jewelry2041993jewel_ry
melty104918363_melt_y
paltry114910403_paltry
poetry1139383poe_try
poultry1235383poultry
psaltry12213803psaltry
qwerty2133583qwert_y
reentry1038033reentry
retry84718083_re_try
salary9515213s_alary
salty85524383s_alt_y
scenery1236563scenery
sceptre1135053sceptre
sealery104011053sealery
sectary1238273s_ectary
seely84522633seel__y
senary93716073s_enary
serry84824123s_e_rry
shelly124414473shel_ly
shelta93111793shelt_a
sheltas10279673sheltas
shelter103214963shelter
shelters113412813shelters
sheltie10109913sheltie
shelvy15377863shel_vy
sherry124510413she_rry
silty84721633s_ilt_y
skelter113610003skelter
skelters12349373skelters
skerry13356103ske_rry
sleety94112653sleet_y
smeary114110803sme_ary
smelly114110363smel_ly
smelt74726783smelt__
smelted10399093smelted
smelter93311913smelter
smelters103310513smelters
smelts85412773smelt_s
sneery93610413sne_ery
spectra11275833spectra
spectre11297773spectre
spelt75430193spelt__
spelter94113703spelter
spelters103912243spelters
spelts84614643spelt_s
speltz174010123spelt_z
stealthy14103063stealthy
stelar64013863stelar_
subentry1344693subentry
suety85318493sue_t_y
svelte9319753svelt_e
sveltely1442843sveltely
svelter10359673svelter
swarthy16466373swarthy
swarty125812383swart_y
swear85316853swe_ar_
swears94114073swe_ars
sweat85628403sweat__
sweated113411543sweated
sweater103712723sweater
sweaters113811063sweaters
sweatily1435473sweatily
sweats94814613sweat_s
sweeney13387003sweeney
sweeny12358843swe_eny
sweepy14447453swe_epy
sweer84918573swe_er_
sweet85330523sweet__
sweeten10267313sweeten
sweeter103212003sweeter
sweetie10157873sweetie
sweets94214433sweet_s
swell84815983swel__l
swelled113211703swelled
sweller103012473sweller
swells93913983swel_ls
sweltered1344453sweltered
sweltrier1242993sweltrier
swept105720603swept__
swiftly1633733swiftly
twenty1236223twent_y
vestry1238623_vestry
wastry12388773_wastry
wealthy16314333_wealthy
weary115620613_we_ary
welly114620013_wel_ly
welt75547863_welt__
welted103715823_welted
welter93417383_welter
welters103516063_welters
welts85225193_welt_s
wetly114511713_we_tly
wintry12498923_wintry

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.406440125.6
2DLD Change Limit1340271116.73319906.0
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.18524870.0
 
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.