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

205 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
trundle830787(None) 
rundle73214231_rundle
trindle83311361trindle
trundled10306391trundled
trundler9256151trundler
trundles9278481trundles
brindle104210102brindle
bundle94315572_bundle
gruntle8257052gruntle
ruddle83414202_ruddle
rundles83214712_rundles
rundlet83114152_rundlet
runkle103611542_runkle
treadle8310102treadle
treddle936432treddle
trindled10388692trindled
trindles93211682trindles
truckle13358862truckle
trudge8318732tru_dge
truffle1384892truffle
trundlers10215002trundlers
trunnel745402trunnel
bindle94516263_bindle
bridle94115463br_idle
brindled12407853brindled
brindles113710223brindles
buddle104313083_buddle
bundled114011303_bundled
bundler104011723_bundler
bundles103515773_bundles
bungle97116113_bungle
candle94321483_candle
caruncle1244713caruncle
caudle93912913cau_dle
cradle93313163cr_adle
crankle133610063crankle
cringle103010353cringle
crinkle13359413crinkle
crude86018573cru_d_e
crumble133410403crumble
crumple13368363crumple
crunode1034713crunode
cuddle104414533_cuddle
curdle95514313_curdle
dandle84218093_dandle
dindle84417223_dindle
drudge9317903dru_dge
drumble12337893drumble
dwindle12415883dwindle
fondle104412943_fondle
fuddle113312103_fuddle
furuncle1342153furuncle
grandee93115513grandee
grandly1238743grandly
granule839473granule
griddle1035503griddle
grudge9388583gru_dge
grumble12349233grumble
grunge8359583grun_ge
gruntled10274943gruntled
gruntles9287233gruntles
handle104219293_handle
hondle103914523_hondle
huddle113712993_huddle
hurdle103712793_hurdle
jungle144012653_jungle
kindle114414233_kindle
lunule638433_lunule
muddle103414633_muddle
nuncle839363_nuncle
prude84615973pru_d_e
prunable1237843prunable
prune75119633prun__e
prunelle1044983prunelle
puddle103914153_puddle
pungle94413573_pungle
raddle84816173_raddle
rankle103414883_rankle
reddle83815913_reddle
riddle83915713_riddle
rondel73212643_rondel
roundel8308853roundel
roundlet9209223roundlet
roundly1136723roundly
rubble104315673_rubble
ruble74521253_ru_ble
ruckle124414583_ruckle
ruddled103010873_ruddled
ruddles92813873_ruddles
rude55632783_ru_d_e
ruffle124111673_ruffle
rule49938423_ru__le
rumble103718813_rumble
rumple103913013_rumple
rundlets9307363_rundlets
rune45236303_run__e
runkled12399013_runkled
runkles114111943_runkles
runlet63821413_run_let
runnel63510663_runnel
rustle63615413_rustle
rutile65217683_rutile
soundly1136683soundly
spindle103210093spindle
straddle10186223straddle
strangle98411503strangle
strudel835783stru_del
struggle10345053struggle
sundae7312873_sundae
swindle11389183swindle
tangle74019973t_angle
thunder1136963thunder
tingle74319073t_ingle
tinkle103714453t_inkle
toddle85811033t_oddle
tousle64514653tou_sle
touzle15429003tou_zle
trachle12311853trachle
trade65026043tr_ad_e
trample11299703trample
trance84718763tran_ce
tranche123312223tranche
trauchle1344963trauchle
treacle939973treacle
treadled1067123treadled
treadler936863treadler
treadles939703treadles
treble8311663tr_eble
treddled1134473treddled
treddles1036263treddles
tremble1138003tremble
trend64817453trend__
trended94011763trended
trendier937913trendier
trendies9312213trendies
trendily1256443trendily
trends75513543trend_s
trendy10469603trend_y
trestle72611363trestle
triable92515393triable
triangle935533triangle
trickle133613443trickle
trifle94012883tr_ifle
trinal6516963trinal_
trine54734603trin__e
triode75311893triod_e
triple84215923tr_iple
triune64210183triun__e
trode65322853tr_od_e
trone55131863tron__e
trouble957713trouble
trounce936823troun_ce
truantly1144643truantly
truce75118693tru__ce
truckled15327313truckled
truckler14297453truckler
truckles14319383truckles
trudged10298043tru_dged
trudgen9357053tru_dgen
trudger9338733tru_dger
trudges9339993tru_dges
true46725853tru___e
trueblue1042163trueblue
trued65117693trued__
truffe1276233tru_ffe
truffled1563993truffled
truffles1485593truffles
trull54012673tru__ll
trulls64110283tru_lls
truly84111553tru__ly
truncate1046283truncate
trundling1135003trundling
trunk94713043trun__k
trunked12358413trunked
trunks10429753trun_ks
trunnels844513trunnels
trustee73514443trustee
tubule839853t_ubule
tuille63012643t_uille
tule45735873t_u__le
tulle54019933t_u_lle
tumble103215643t_umble
tunable92511313t_unable
tundra736423t_undra
tune45635863t_un__e
tunicle9308033t_unicle
tunnel64310633t_unnel
turnable1037853turnable
turnsole844693turnsole
turtle63213573t_urtle
tussle637143t_ussle
twaddle12245713twaddle
twangle1145813twangle
tweedle1134193tweedle
twiddle12305483twiddle
twinkle1464773twinkle
unbundle1144843unbundle
uncle7317053__uncle
unde55825483__und_e
undee65327273__undee
undue66715553__undue
wandle105316663_wandle
windle104617953_windle
wrangle1137383wrangle
wrinkle14296923wrinkle

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 Limit1340272057.06318975.9
3Display Results2052050.0802562.5
 (SQL Overall)1786912057.56323627.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.