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

152 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
twattle106427(None) 
tattle64115651t_attle
twattled1273461twattled
twattles1154381twattles
wattle94314211_wattle
battle85217862_battle
brattle9249252brattle
cattle85118902_cattle
prattle9208832prattle
rattle64717612_rattle
tattie64817512t_attie
tattled84311482t_attled
tattler73112212t_attler
tattles73616282t_attles
tittle63613322t_ittle
twaddle12245712twaddle
twangle1145802twangle
wattled113610502_wattled
wattles103814072_wattles
battled104213123_battled
battler94113383_battler
battles94517683_battles
battue84311003_battue
bottle84916073_bottle
brattled11196723brattled
brattles10199333brattles
brittle9168603brittle
cantle84522153_cantle
castle84918963_castle
cattie85221023_cattie
chattel12388893chattel
cuittle946403cuittle
cuttle84113893_cuttle
dartle73714833_dartle
dottle74212503_dottle
embattle1253273embattle
fettle93713123_fettle
guttle74111973_guttle
hantle94318203_hantle
kettle104311613_kettle
kittle104012173_kittle
latte55426303_latt_e
little63312163_little
mantle84420923_mantle
matte75626843_matt_e
mettle83815723_mettle
mottle84116053_mottle
nettle64514583_nettle
pattee84323383_pattee
pattie84020963_pattie
pettle84116053_pettle
pottle84416103_pottle
prattled11246533prattled
prattler10166343prattler
prattles10189403prattles
rattled84012953_rattled
rattler74012743_rattler
rattles73217303_rattles
rattly94111543_rattly
scuttle936463scuttle
settle63915663_settle
shuttle1046103shuttle
skatole1135693skatole
skittle1135533skittle
spatzle1834583spatzle
spittle937923spittle
sprattle1054763sprattle
startle72511123startle
swaddle12276743swaddle
swale85221593swa__le
swathe125514113swa_the
swatted114110693swatted
swatter104113323swatter
table75429603t_a_ble
tackle123815733t_ackle
tactile9310613tactile
taille63116923t_aille
tale46154163t_a__le
tamale83717403t_amale
tangle74019953t_angle
tartlet72218483t_artlet
tartly96014023t_artly
taste55127233t_ast_e
tate44748603t_a_t_e
tatted74920533t_atted
tatter64024573t_atter
tattier74216243t_attier
tatties74120343t_atties
tattily10409993t_attily
tattlers8369693t_attlers
tattoo6310973t_attoo
tatty84720183t_att_y
tautly9499503t_autly
teakettle1351483teakettle
teatime9310083teatime
teazle15329553tea_zle
textile1437223textile
thistle10107803thistle
throttle1164083throttle
thwartly1742703thwartly
title54721073t__itle
tittie63213153t_ittie
tittles73413253t_ittles
tootle62613813t_ootle
tortile7313193tortile
totable92313363totable
towable121910113towa_ble
trachle12311853trachle
tractile10311073tractile
trample11299703trample
trestle72611363trestle
tsatske1141833tsatske
turtle63213573t_urtle
twaddled14254623twaddled
twaddler13314643twaddler
twaddles13315723twaddles
twae74719573twa___e
twangled1364173twangled
twangler1244113twangler
twangles1245743twangles
twasome1244623twasome
twat75831513twa_t__
twats86616603twa_t_s
twattling1332693twattling
tweedle1134193tweedle
twiddle12305483twiddle
twinkle1464773twinkle
twitted11326633twitted
twitter10278093twitter
vittle94711753_vittle
wabble133714843_wabble
waddle114715303_waddle
waffle15369183_waffle
waggle113612303_waggle
wale74546433_wa__le
wamble134415753_wamble
wandle105316663_wandle
wangle103817503_wangle
warble113516603_warble
warsle93112923_warsle
warstle10328013_warstle
waste86125053_wast_e
watape11208483_watape
watt75545413_watt__
wattage1186983_wattage
wattape12135383_wattape
watter93221983_watter
wattless11268723_wattless
watts86923093_watt_s
whittle13106103whittle
wintle94014603_wintle
wrastle10368993wrastle

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 Limit1340271526.72019944.5
3Display Results1521520.0463304.3
 (SQL Overall)1786911527.17224915.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.