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

158 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
townlet104973(None) 
tonlet62924701to_nlet
townlets1134771townlets
howlet123518342how_let
moonlet92413272moonlet
owlet83324462_ow_let
toilet66228092to_ilet
tonlets73212502to_nlets
toweled112410222toweled
townee92815212town_ee
townees10269782townees
townie93312302townie_
townies103113622townies
townless1135652townless
bomblet13412263bomblet
bonnet85524633bo_nnet
booklet132312643booklet
boomlet112412273boomlet
boweled132810693boweled
bowled125018143bow_led
bowleg12369183bow_leg
bowler114217313bow_ler
collet84030363co_llet
cornet84436733corn_et
corslet9318063corslet
couplet114717943couplet
cowled125218393cow_led
crownet123714113crown_et
doublet103914033doublet
doweled12269773doweled
downbeat1444953downbeat
downed115314783down_ed
downer104414923down_er
downier11299703downier
downiest122710603downiest
downless1236363downless
fowled133914103fow_led
fowler123712583fow_ler
goblet93219483go_blet
goglet84618583go_glet
gowned114410133gown_ed
hooklet142510813hooklet
hornet94926433horn_et
howled134014973how_led
howler123514313how_ler
howlets13329223how_lets
inlet53732403__inlet
jowled174210803jow_led
moonlets10247473moonlets
moonlit9229333moonlit
moonset92413043moonset
nonet54540843no_n_et
omelet8317073_omelet
oncet74626543_o_ncet
onset54730173_o_nset
outlet63728683_outlet
owlets93110393_ow_lets
owned95113233_own_ed
owner84613313_own_er
rootlet73015733rootlet
roundlet9209223roundlet
roweled11269863roweled
runlet63821413_runlet
sonnet65923503so_nnet
tablet84227643t_ablet
tartlet72218483tartlet
tawney12338233tawn_ey
tawnier10318463tawnier
tawnies102812503tawnies
tawniest11279343tawniest
telnet6518833teln_et
templet112712003templet
tenet55542213t_en_et
toddle85811033toddle_
toddled10328823toddled
toddler9379043toddler
toddles93211533toddles
toggle83810873toggle_
toggled10428653toggled
toggler9399193toggler
toggles93710973toggles
toile54626493to_ile_
toiled74420323to_iled
toiler63918283to_iler
toiles63923513to_iles
toilets74112913to_ilets
tole46052903to__le_
toled65934923to__led
toles55147133to__les
tolled73819033to_lled
toller63819443to_ller
tone46953743to_n_e_
toned65435343to_n_ed
toner55336243to_n_er
tones56048663to_n_es
toney86027413to_n_ey
tonged86518913to_nged
tonger74719693to_nger
tonier65520713to_nier
toniest73218903to_niest
tonne54921433to_nne_
tonner64819203to_nner
tonnes65320853to_nnes
tooled74918903to_oled
tooler63818613to_oler
toonie63617993toonie_
toonies73719883toonies
tootle62613813tootle_
tootled83511043tootled
tootler73511123tootler
tootles72915603tootles
topple104411323topple_
toppled12348843toppled
topples113111653topples
toquet154414683to_quet
totaled839693totaled
tousle64514653tousle_
tousled84710363tousled
tousles74113933tousles
touzle15429003touzle_
touzled17367153touzled
touzles16359223touzles
towable121910113towable_
towage1039833towage_
towages1139233towages
towboat1258303towboat
towed95134583tow__ed
towel84920523tow__el
towelette1243403towelette
towelled1236353towelled
towels94314643towel_s
tower85729203tow__er
towered112911403towered
towhee122613883tow_hee
towhees13277793towhees
towie85821873tow_ie_
towies93521193tow_ies
towmont1277633towmont
town76928703town___
townish13167933townish
towns86018883town__s
townsmen1344073townsmen
townwear1442293townwear
towny116114493town__y
trawlnet1146583trawlnet
trinket11314813trinket
triolet73219523triolet
triplet94319213triplet
troweled12106113troweled
troweler11106063troweler
tweet84823983t_w_eet
twilit949553t_wilit
twinjet1735113twinjet
twinset1039373twinset
unlet54133333__unlet
veinlet101310573veinlet
yowled133811093yow_led
yowler123310043yow_ler

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.436409841.7
2DLD Change Limit1340271586.84619577.4
3Display Results1581580.0602633.3
 (SQL Overall)1786911587.34224338.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.