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

417 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
twirled1138598(None) 
swirled11308221swirled
thirled11328091thirled
tirled74714361t_irled
twilled11398031twilled
twirler10285201twirler
birled94416992_birled
dirled84514902_dirled
skirled12348182skirled
swilled113611832swilled
tailed74424662tai_led
tiled64832942t_i_led
tilled74722952t_illed
tired65228902t_ir_ed
titled73815002t_itled
toiled74420322toi_led
trifled113711962trifled
trilled84116312trilled
tripled104113832tripled
twiddled14284632twiddled
twigged13345282twigged
twined104413122twi_ned
twinged12398362twinged
twinkled1663942twinkled
twinned11366332twinned
twirl85011942twirl__
twirlers11274302twirlers
twirlier1133512twirlier
twirls9478122twirl_s
twirly12427082twirl_y
twisted11277432twisted
twitted11326632twitted
whirled14368042whirled
wiled95231552_wi_led
willed104722452_willed
wired95327642_wir_ed
ailed66240283_ai_led
aired66032923_air_ed
airted74214503_airted
aisled74516183_aisled
ariled75620323ari_led
attired8238913attir_ed
awarded1236223awarded
bailed94726653bai_led
billed94224903_billed
birded104414303_birded
birle75023633_birle_
birler85715083_birler
birles84920643_birles
birred94713203_birred
boiled95020953boi_led
bridled113611143bridled
burled94825383_burled
byrled12437173_byrled
cairned1037643cairned
ceiled94114953cei_led
chilled133310933chilled
chirked173810333chirked
chirmed15379733chirmed
chirped15379783chirped
chirred133612123chirred
circled1237583_circled
coiled95123943coi_led
curled95021653_curled
dialed84716453_dialed
dilled84122223_dilled
dirked124912273_dirked
doiled84817293doi_led
drilled94711673drilled
dwarfed1533483dwarfed
dwelled12337593dwelled
dwindled14385023dwindled
dwined114610213dwi_ned
enisled82510223enisled
exiled144712463exi_led
failed105421603fai_led
faired105915773fair_ed
fairlead1243513fairlead
filed95331903_fi_led
filled104922263_filled
fired94829743_fir_ed
firmed125411883_firmed
flirted11428673flirted
foiled104618403foi_led
frilled113911603frilled
furled104717053_furled
gilled84521633_gilled
girded93712493_girded
girdled10217453_girdled
girned84010513_girned
girted83912873_girted
gnarled9287723gnarled
grilled94012833grilled
guiled84315383gui_led
hailed104122743hai_led
haired105117173hair_ed
heiled104415613hei_led
heired103813043heir_ed
hilled104022223_hilled
hired95226263_hir_ed
hirpled13157143_hirpled
hirsled11118113_hirsled
hurled104617453_hurled
icicled1234293icicled
idled74915213__idled
ired55131873__ir_ed
irked104510923__irked
isled64615993__isled
jailed144917423jai_led
killed113918773_killed
kirned11408623_kirned
kirtled12287033_kirtled
knurled1244653knurled
laired75216813lair_ed
mailed95326753mai_led
marled95523163_marled
milled94326173_milled
mired85729223_mir_ed
misled94719313_misled
moiled94318863moi_led
nailed74021493nai_led
nilled73919453_nilled
nurled74016233_nurled
oiled64429473_oi_led
outwhirled1742373outwhirled
outwiled1237603outwi_led
outwilled1345013outwilled
paired95017523pair_ed
parled94626293_parled
pearled10411553pearled
periled10316323periled
piled85232993_pi_led
pilled94222753_pilled
prilled104713003prilled
purled94520753_purled
quilled17329283quilled
quired163711953quir_ed
quirked21325433quirked
quirted17369213quirted
railed74727543rai_led
rewired115413283rewir_ed
rifled104115003_rifled
riled65833253_ri_led
rilled74525653_rilled
roiled74320053roi_led
sailed74327763sai_led
shilled113313623shilled
shirked153710463shirked
shirred113710503shirred
sidled84215173_sidled
sired66134283_sir_ed
skilled123110863skilled
skirred12347083skirred
skirted12388613skirted
smiled93716433smi_led
smirked14307233smirked
snarled83612363snarled
soiled73822473soi_led
spieled104811883spieled
spiled94621993spi_led
spilled103613623spilled
spiraled1137733spiraled
spired94921863spir_ed
spirted103913073spirted
stifled113511093stifled
stilled83314793stilled
stirred8359703stirred
swarded1238153swarded
swarmed1367483swarmed
swelled113211703swelled
swerved1455703swerved
swigged13327183swigged
swiller103211663swiller
swindled13307623swindled
swinged123810793swinged
swingled13337433swingled
swinked15349033swinked
swiped123811093swi_ped
swiple11379233swiple_
swiples12339643swiples
swirl84514143swirl__
swirlier1135213swirlier
swirls94010133swirl_s
swirly12439253swirl_y
swished14418843swished
swived133610633swi_ved
swiveled1544163swiveled
swizzled2053013swizzled
tabled94020043t_abled
tackled143913193tackled
tailer63823733tai_ler
taille63116923taille_
tailles72516473tailles
tainted83512423tainted
tangled94214643tangled
tared69340053t_ar_ed
tarred74720283t_arred
tarried83914133tarried
tarted74923373t_arted
tattled84311483tattled
teared75722153tear_ed
teazled17326833teazled
templed12278563templed
termed94816703t_ermed
thieved1434973thieved
thighed1535273thighed
thinned11399173thinned
third95912493thir__d
thirl85416823thirl__
thirls95012063thirl_s
thirsted1235213thirsted
tholed105113873t_holed
thorned11479403thorned
thrilled1235493thrilled
thrived14458183thrived
thwarted1533363thwarted
tiaraed837053tiaraed
ticced11438443t_icced
ticked134720523t_icked
tickled144313133tickled
tided76322513t_i_ded
tidied83613273t_idied
tied55535213t_i__ed
tierced10347053tierced
tiered73613973t_iered
tiffed13368393t_iffed
tilde65017343t_i_lde
tile45451443t_i_le_
tiler56131023t_i_ler
tiles55542103t_i_les
tiller64222543t_iller
tilted74616863t_ilted
timed85223613t_i_med
tined65434533t_i_ned
tinged84220813t_inged
tingled93712803tingled
tinkled123910473tinkled
tinned74317533t_inned
tinted74419533t_inted
tipped114418263t_ipped
tippled12358393tippled
tirade7311693t_irade
tire46143353t_ir_e_
tires55437493t_ir_es
tirl45029923t_irl__
tirls54519803t_irl_s
tithed104115593t_ithed
title54721073t_itle_
titles63719923t_itles
toddled10328823toddled
toggled10428653toggled
toile54626493toi_le_
toiler63918283toi_ler
toiles63923513toi_les
toilet66228093toi_let
toited74016753toi_ted
toled65934923t__oled
tolled73819033t_olled
tooled74918903t_ooled
tootled83511043tootled
toppled12348843toppled
totaled839693totaled
toured74216153tour_ed
tousled84710363tousled
touzled17367153touzled
toweled112410223toweled
towelled1236353towelled
towered112911403tower_ed
trailed83415673trailed
trawled113411523trawled
trebled1038483trebled
treed65626733t__reed
triaged92810443triaged
triced95518673tri_ced
tricked144016163tricked
trickled152610433trickled
triclad1037443triclad
tried65026913t__ried
trifle94012883trifle_
trifler103912153trifler
trifles103814823trifles
trigged10359853trigged
triller74215893triller
trimmed12348933trimmed
trindled10388693trindled
trined74920713tri_ned
triolet73219523triolet
triple84215923triple_
triples94616873triples
triplet94319213triplet
triplex16447803triplex
tripped123911693tripped
trolled84312263trolled
trued65117693t__rued
tuille63012643tuille_
tuilles72411923tuilles
tumbled123412243tumbled
turfed103110963t_urfed
turned73914473t_urned
turtled8309683turtled
tussled835413tussled
twaddled14254623twaddled
twanged12387283twanged
twangled1364173twangled
twattled1273463twattled
tweaked1534403tweaked
tweed94915093tw__eed
tweedled1332833tweedled
tweeted11336583tweeted
tweezed20274993tweezed
twice104711123twi_ce_
twiddle12305483twiddle_
twiddler13244873twiddler
twiddles13265613twiddles
twier84713293twi__er
twiggen12333503twiggen
twigless1293663twigless
twilit949553twi_lit
twill85612723twi_l_l
twills9489793twi_lls
twine85822363twi_ne_
twiner94012593twi_ner
twines94717273twi_nes
twinge104210403twinge_
twinges11409453twinges
twinier1037313twinier
twinjet1735113twinjet
twinkle1464773twinkle_
twinkler1564073twinkler
twinkles1535073twinkles
twinset1039373twinset
twirliest1234503twirliest
twirling12246243twirling
twirp10468943twir__p
twirps11415013twir_ps
twister10308953twister
twitched17155033twitched
twitter10278093twitter
tyred95816433t_yr_ed
untwilled1343873untwilled
unwilled1277823unwilled
vailed104619293vai_led
veiled103714543vei_led
vialed105112593_vialed
wailed104823593_wailed
waired106015833wair_ed
waled94330993_w_aled
walled104021293_walled
warbled133212163_warbled
warded115021043_warded
wared96339873_war_ed
warked144421213_warked
warmed124516893_warmed
warned104018913_warned
warped124816413_warped
warred104019853_warred
warsled112910443_warsled
warted104223233_warted
wauled104713963_wauled
wawled133811703_wawled
weirded1234513weirded
welled103820213_welled
whaled134612033_whaled
whiled134514133_whiled
whirler13307603whirler
whirred14386943whirred
whorled14366903whorled
wicked164317413_wicked
widdled133511233_widdled
wield95213913_wiel_d
wielded12216683_wielded
wifed125117743_wi_fed
wigged124413583_wigged
wiggled13299603_wiggled
wiglet105519153_wiglet
wild85126513_wi_l_d
wilded113714503_wilded
wile75944373_wi_le_
wiles85437873_wi_les
willer94021063_willer
willet95124833_willet
willied114611563_willied
wilted103915713_wilted
wimbled15298153_wimbled
wimped144211513_wimped
wimpled15338823_wimpled
winced124415343_winced
winded114918213_winded
windled123713483_windled
wined94434183_wi_ned
winged114620833_winged
winked144018603_winked
winkled15299593_winkled
winned104017013_winned
wintled11339843_wintled
wiped114722083_wi_ped
wire75839813_wir_e_
wirer85124953_wir_er
wires86034913_wir_es
wirier94215553_wirier
wised95123343_wi_sed
wished134417513_wished
wisped123411893_wisped
wissed104114643_wissed
wisted104120273_wisted
wited94727143_wi_ted
withed134416233_withed
witted104216813_witted
wived125121503_wi_ved
wooled103715503_wooled
worded114316623_worded
worked145314703_worked
world96915363_worl_d
wormed124314303_wormed
wried95518563_w_ried
wyled124611843_w_yled
yirred10426963_yirred

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.420425454.8
2DLD Change Limit1340274176.69020033.9
3Display Results4174170.1532725.5
 (SQL Overall)1786914177.26324602.9
 
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.