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 “trundlers” 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
trundlers1021500(None) 
trundler9256151trundler_
trundles9278481trundle_s
bundlers11399182_bundlers
rundles83214712_rundle_s
rundlets9307362_rundlets
thunders1236952thund_ers
treadlers1045892treadlers
trindles93211682trindle_s
trucklers15295582trucklers
trudgers10256862tru_dgers
trundle8307872trundle__
trundled10306392trundle_d
blunders113911343blund_ers
bounders114314113bound_ers
boundless1235183boundless
branders114313093brand_ers
brandless1236123brandless
bridlers11359183br_idlers
brindles113710223brindle_s
brunchers16296253brunchers
bundler104011723_bundler_
bundles103515773_bundle_s
bunglers11398483_bunglers
candlers114214103_candlers
chandlers15387673chandlers
cradlers11309203cr_adlers
crullers1047303cru_llers
crunchers16316243crunchers
cuddlers12388383_cuddlers
curdlers11368493_curdlers
dandlers103912053_dandlers
daunders10278473daund_ers
drudgers11326853dru_dgers
fondlers12338023_fondlers
founders123911673found_ers
funders113813933_fund_ers
grinders103410423grind_ers
grounders1156783ground_ers
groundless1243473groundless
grudgers11266753gru_dgers
gruelers936173gru_elers
gruellers1034183gruellers
grumblers14245023grumblers
grungers10298503grun_gers
grunters9359033grun_ters
gruntles9287233gruntle_s
handlers124014143_handlers
hounders123111713hound_ers
huddlers13337633_huddlers
hurdlers12337493_hurdlers
kindlers13318483_kindlers
krullers1234133kru_llers
landlers94312833_landlers
launders9358743laund_ers
maunders11348343maund_ers
muddlers12428813_muddlers
plunders11329833plund_ers
pounders113113283pound_ers
pruners93710723prun__ers
puddlers12298683_puddlers
renders83821673_rend_ers
riddlers10269103_riddlers
rindless92510193_rindless
rounders92613693round_ers
roundlets10175293roundlets
rudders93210653_ru_dders
ruddles92813873_ruddle_s
rufflers14347193_rufflers
rulers64317093_ru__lers
rumblers123610743_rumblers
rundle73214233_rundle__
rundlet83114153_rundle_t
rungless956733_rungless
runkles114111943_runkle_s
runless72810423_run_less
runlets73310773_run_lets
runners74212453_run_ners
runovers1134473_runovers
rustlers8339853_rustlers
sounders93214113sound_ers
soundless1035533soundless
spindlers12286453spindlers
straddlers12203823straddlers
stranders10389933strand_ers
stranglers11396823stranglers
strugglers12273063strugglers
sunders84120053_sund_ers
swindlers13306033swindlers
tanglers92911973t_anglers
taunters8259273taun_ters
tenders83719723t_end_ers
thunder1136963thund_er_
thunderers1443973thunderers
thundery1533823thund_ery
tiddlers10288653t_iddlers
tinders84219173t_ind_ers
tinglers93710593t_inglers
tinklers12298183t_inklers
toddlers10346963t_oddlers
traders84316953tr_ad_ers
trailers82912923tr_ailers
tramplers13305883tramplers
transfers1238053transfers
travelers12266773travelers
trawlers113310203tr_awlers
treaders93311843tread_ers
treadler936863treadler_
treadles939703treadle_s
treadless1036003treadless
treddles1036263treddle_s
tremblers1334483tremblers
trenchers14288073trenchers
trendier937913trendier_
trendies9312213trendie_s
triflers113110213tr_iflers
trillers83613493tr_illers
trindle83311363trindle__
trindled10388693trindle_d
trollers83211213tr_ollers
troublers1135003troublers
trouncers1134803troun_cers
trowelers12105263trowelers
truceless11235393truceless
truckers14279013tru_ckers
truckler14297453truckler_
truckles14319383truckle_s
trudgens10255153tru_dgens
trudger9338733tru_dger_
trudges9339993tru_dge_s
truffles1485593truffle_s
trundling1135003trundling
trunnels844513trun_nels
trussers8348283tru_ssers
trusters83112263tru_sters
trustless955953trustless
truthless1244033truthless
tumblers123110623t_umblers
tummlers12295703t_ummlers
tuneless837913t_uneless
tuners64417343t_un__ers
tunnelers953463tunnelers
turners73912893turn__ers
turnovers1243283turnovers
turtlers8258203t_urtlers
twaddlers14343613twaddlers
twanglers1363433twanglers
twiddlers14313693twiddlers
twinklers1633063twinklers
undoers82910583__undoers
woundless1334033woundless
wranglers1344273wranglers

Search took 7 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 Filter1786911486410.420425454.8
2DLD Change Limit1486411526.44023080.9
3Display Results1521520.0602533.3
 (SQL Overall)1786911526.92025822.4
 
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.