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

136 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
treasons84868(None) 
reasons72514941_reasons
treason748761treason_
outreasons1053072outreasons
reason62616332_reason_
seasons72614232_seasons
telsons739222t_elsons
treasonous1052692treasonous
unreasons9114342unreasons
weasons102310582_weasons
arsons63917213ar__sons
beacons11410733_beacons
breasts939703breas_ts
cratons94316033cr_atons
crayons12439233cr_ayons
creasers103612843creasers
creases94020963creas_es
creasing113314443creasing
creatins103617513creatins
creations112614543creations
creators102814413creators
creosols1045723creosols
crepons1139323cre_pons
cresols939653cre_sols
crimsons1245633crimsons
deacons10310393_deacons
dragons938383dr_agons
erasions8310983er_asions
erepsins1037443erepsins
freemasons1551653freemasons
frissons1145043frissons
greasers93410253greasers
greases84816713greas_es
greasing102811393greasing
greatens9307593greatens
greisens954653greisens
grisons838993gr_isons
keelsons1244093keelsons
kelsons1137323_kelsons
lessons73811023_lessons
masons83916513__masons
mesons83215843_me_sons
nelsons738003_nelsons
organons945583organons
orisons7310563or_isons
outreason943433outreason_
persons93717013_persons
preseasons1244053preseasons
presong1039843pre_song
pressors103212693pressors
prisons9313223pr_isons
racons84319343_r_acons
radons74118533_r_adons
ramsons939563_ramsons
rayons94113343_r_ayons
readorns938283_readorns
reagins84215643_reagins
reasoned9410733_reasoned
reasoner849343_reasoner
reasoners947113_reasoners
reavows1335273_reavows
reckons13269653_reckons
recons84922993_re_cons
redons75222183_re_dons
regions83613473_regions
reseasons944873reseasons
resins64528773_re_sins
resods74116303_re_sods
resows93915353_re_sows
season62714903_season_
stemsons1045003stemsons
stepsons1045663stepsons
sternsons944663sternsons
stetsons845623stetsons
stressors955793stressors
talons64019443t__alons
tarragons1044483tarragons
tauons63412673t__auons
taxons134211503t__axons
teapots939053t_eapots
teapoys1235963t_eapoys
teasels74311313t_easels
teasers75317243t_easers
teases65426273t_eas_es
teashops1345733t_eashops
teasing83918513t_easing
teaspoons1143863t_easpoons
teflons1036543t_eflons
telson6310293t_elson_
tendons8311473t_endons
tenons62916603t_e_nons
tensions8310223t_ensions
tensors72712373t_ensors
ternions838813ternions
testons7313563t_estons
threatens1254673threatens
toreadors1045153toreadors
trains64725343tr_a_ins
trans54933043tr_a__ns
transoms1048933transoms
trapans92812463tr_apans
trashes104119263tr_ashes
trass56226473tr_as__s
trasses74819323tr_asses
travois1037883tr_avois
treacles1039703treacles
treaders93311843treaders
treading103515333treading
treadles939703treadles
treads74817923trea__ds
treasure846753treasure
treasures946633treasures
treasury1143793treasury
treaters83615843treaters
treaties8316983treaties
treating92519613treating
treats64821693trea__ts
treens65317873tre__ens
treetops1045463treetops
tremors93711233tre_mors
trepans92311593tre_pans
tress55423163tre_s__s
tressels8367653tressels
tresses73719543tre_sses
tressour844573tressour
tressours943893tressours
triazins1738353triazins
trigons84312093tr_igons
tritons73814883tr_itons
trogons83410723tr_ogons
trypsins1344903trypsins
unreason8104483unreason_
ureases74416723ureas_es
weakons14287803_weakons
weapons12278603_weapons
weason93210823_weason_

Search took 9 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.420425454.8
2DLD Change Limit1461621367.61019206.6
3Display Results1361360.0632158.7
 (SQL Overall)1786911368.09322079.7
 
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.