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

219 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
treadler93686(None) 
treader84113831tread_er
treadle8310101treadle_
treadled1067121treadled
treadlers1045891treadlers
treadles939701treadles
cradler102910512cr_adler
reader73628292_read_er
readier83117422_readier
realer63528592_rea_ler
threader1256732thread_er
threadier1354472threadier
trader75218762tr_ad_er
trailer73015392tr_ailer
trawler104011902tr_awler
treacle939972treacle_
treacles1039702treacles
treaclier1144152treaclier
treaded95014282tread_ed
treaders93311842tread_ers
treadless1036002treadless
treater74219832trea_ter
treddle936432treddle_
treddled1134472treddled
treddles1036262treddles
trembler1235362trembler
trendier937912trendier
trundler9256152trundler
beader94623793_bead_er
beadier103513913_beadier
beadle93314683_beadle_
beadles103414733_beadles
brawler124310233br_awler
breacher153011503breacher
breaded115014063bread_ed
breadless1235943breadless
breaker133912923brea_ker
breather133610593breather
breeder103210043breed_er
bridler103811073br_idler
broader103412613broad_er
cradle93313163cr_adle_
cradled113410813cr_adled
cradlers11309203cr_adlers
cradles103114133cr_adles
crawler123510463cr_awler
creakier14328333creakier
creamer113714093crea_mer
creamier12319063creamier
creaser94415743crea_ser
creasier103210193creasier
deader84220473_dead_er
deadlier1036863_deadlier
dealer74122143_dea_ler
drawler11338593dr_awler
dreaded103612023dread_ed
dreamer104110843drea_mer
dreamier11287293dreamier
drearier9297923drearier
dredger10347453dre_dger
frailer10319943fr_ailer
freakier15246483freakier
grader84919693gr_ad_er
greaser83913083grea_ser
greasier9298083greasier
greater84416493grea_ter
greedier1036083greedier
grenadier1144093grenadier
header104422543_head_er
headier113212953_headier
healer94221803_hea_ler
kneader1275893knead_er
ladler74314933__ladler
leader74824653_lead_er
leadier83212723_leadier
meddler11319953_meddler
needler8388893_needler
pearler9310373_pearler
pedaler103410693_pedaler
peddler113210493_peddler
pedler93614623_pe_dler
pleader103511753plead_er
preacher153211373preacher
prealter1048863prealter
preaver121011613prea_ver
prevailer1445153prevailer
railer64524933_r_ailer
reacher123718293_reacher
readded103310733_readded
readers83823773_read_ers
readied93316623_readied
readies83324713_readies
reales64934123_rea_les
realter73716313_realter
reamer84325213_rea_mer
reaper84223143_rea_per
rearer64928913_rea_rer
reaver94524733_rea_ver
recaller1039323_recaller
redder83918143_re_dder
reddle83815913_reddle_
reddled102912323_reddled
reddles93315773_reddles
redleg839273_re_dleg
reedier83815303_reedier
reeler63822573_re_eler
regaler83814623_regaler
render74024143_rend_er
retailer82911573_retailer
reveler104116343_reveler
reviler104314973_reviler
riddler93411263_riddler
sealer63928963_sea_ler
spreader1137483spread_er
steadier937313steadier
stealer72913973stea_ler
straddler11205113straddler
streaker12229483strea_ker
streakier1334843streakier
streamer10239513strea_mer
streamier1155763streamier
streamlet1146043streamlet
tailer63823733t__ailer
taler56034863t__a_ler
taller63721963t__aller
teacher123714833t_eacher
tearer64822903t_ea_rer
tearier73815613t_earier
teaseler8176573t_easeler
teaser65421523t_ea_ser
teazle15329553t_eazle_
teazled17326833t_eazled
teazles16308923t_eazles
tedder83312163t_e_dder
teller63519813t_e_ller
tender74121843t_end_er
thaler94613103t_ha_ler
theater104014253thea_ter
threaded1366323thread_ed
threaders1365743thread_ers
threadless1442473threadless
threaper1345143threa_per
tiddler93110003t_iddler
tireder837703tire_d_er
toddler9379043t_oddler
toreador945003toread_or
tracer84820233tr_a_cer
tracker133515173tr_acker
trade65026043tr_ad_e_
traded85717683tr_ad_ed
traders84316953tr_ad_ers
trades75724503tr_ad_es
traducer1144583tr_aducer
trailed83415673tr_ailed
trailers82912923tr_ailers
trainer73316793tr_ainer
tramper113812163tr_amper
trampler12278013trampler
trapper113912803tr_apper
trasher104416133tr_asher
traveler11328433traveler
trawled113411523tr_awled
trawlers113310203tr_awlers
trawley13317303tr_awley
treachery1744693treachery
treacly1237093treacl_y
tread64821703tread___
treading103515333treading
treadling1137503treadling
treads74817923tread__s
treasure846753treasure
treasurer944253treasurer
treated83618703trea_ted
treaters83615843trea_ters
treaties8316983treaties
treble8311663tre_ble_
trebled1038483tre_bled
trebles9311443tre_bles
trekker1034733tre_kker
tremble1138003tremble_
trembled1335253trembled
tremblers1334483tremblers
trembles1237353trembles
tremblier1343283tremblier
trencher13279313trencher
trended94011763trend_ed
trendies9312213trendies
trepanner1143523trepanner
tressier847963tressier
trestle72611363trestle_
trestles83012553trestles
triable92515393triable_
trifler103912153tr_ifler
triller74215893tr_iller
trindle83311363trindle_
trindled10388693trindled
trindles93211683trindles
troller73913173tr_oller
troubler1035293troubler
troweler11106063troweler
truckler14297453truckler
trudger9338733tr_udger
trundle8307873trundle_
trundled10306393trundled
trundlers10215003trundlers
trundles9278483trundles
twaddler13314643twaddler
tweakier1533143tweakier
tweedier1253623tweedier
tweedle1134193tweedle_
tweedled1332833tweedled
tweedles1234113tweedles
twiddler13244873twiddler
unreadier1045013unreadier
vealer94016543_vea_ler
wheedler1543543wheedler
wreaker143610043wrea_ker
wreather14268603wreather
wrestler11306993wrestler

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622196.71621763.3
3Display Results2192190.0802737.5
 (SQL Overall)1786912197.21924752.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.