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

119 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
treatises931037(None) 
treaties8316981treati_es
treatise8311101treatise_
creatines112814432creatines
creatives14279692creatives
realises82420182_realises
teatimes1039442t_eatimes
teratisms11410072teratisms
trellises947022trellises
abatises10311013_abatises
betises94816123_be_tises
braises93818873br_a_ises
breathes134212903breat_hes
brewises1337213bre_wises
clematises1445733clematises
creases94020963crea__ses
creates95225203creat__es
creatine103417413creatine_
creatins103617513creati_ns
creations112614543creations
creative132812803creative_
creatures1138413creatures
creolises1157893creolises
dramatises1356763dramatises
dreamtimes1542193dreamtimes
drearies92313413dreari_es
entreaties1048113entreati_es
ergatives1346443ergatives
fraises104215693fr_a_ises
greases84816713grea__ses
greatness1036903greatness
idealises1047783idealises
iritises839973ir_itises
keratoses1346093keratoses
meatuses1038203_meatuses
organises1048683organises
poetises10313953poe_tises
practises1349623practises
praises94121103pr_a_ises
praxises1739063pr_axises
precises123218333pre_cises
predatisms1545243predatisms
prelatisms1445703prelatisms
premises123018273pre_mises
prentices131111903prentices
prestiges12310593prestiges
pretties10615133pretti_es
previses133814283pre_vises
privatises15187403privatises
raises64826543_r_a_ises
ratines75328583_r_atines
ratites74920683_r_atites
readies83324713_readi_es
realise73021813_realise_
realised92214533_realised
realiser82512563_realiser
realisers9248323_realisers
realisms102212163_realisms
realists83014843_realists
realizes173116843_realizes
realties8514853_realti_es
relatives1239963_relatives
remises93423483_re_mises
reprises102615463_reprises
reptiles103913063_reptiles
reraises8415643_reraises
rerises73525883_re_rises
reties65436193_re_ti_es
retiles74426993_re_tiles
retimes95020173_re_times
retines75134673_re_tines
retires74726213_re_tires
revises104220533_re_vises
steatites939843steatites
tamises92715973t__amises
tapises92914013t__apises
teases65426273t_ea__ses
teatime9310083t_eatime_
tectites1039993t_ectites
tektites1236613t_ektites
tennises82810133t_ennises
teratism10312173teratis_m
termtimes1354803termtimes
tetanises979873tetanises
textiles1536833t_extiles
theatres11298633theat_res
thelitises1354873thelitises
theorises1247813theorises
totalises9311783totalises
traipses1036873tr_aipses
trapeses1039153tr_apeses
trasses74819323tr_a_sses
traumatises1354453traumatises
travoises1245863travoises
treacles1039703trea_cles
treadles939703trea_dles
treadless1036003treadless
treasures946633treasures
treated83618703treat__ed
treater74219833treat__er
treaters83615843treat_ers
treating92519613treati_ng
treats64821693treat___s
trehaloses1343363trehaloses
trellised1044653trellised
trematodes1343503trematodes
trendies9312213trendi_es
trephines1448483trephines
tresses73719543tre__sses
trestles83012553trest_les
triadisms1246453triadisms
triazines1847543triazines
trusties82712853trusti_es
tsetses785453tse_t_ses
twenties1137503twenti_es
urbanises11106643urbanises
ureases74416723urea__ses
uveitises1243643uveitises
wreathes14299893wreat_hes

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411197.01621186.0
3Display Results1191190.0462587.0
 (SQL Overall)1786911197.48523873.2
 
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.