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 “terpeneless” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

51 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
terpeneless136177(None) 
sereneness1047133ser_eneness
terpenes102111573terpen__e_s
terseness948403tersen__ess
tersenesses1149043tersenesses
treeless839283t_r_e_eless
breezeless2141694_breezeless
brineless1136244_br_ineless
defenseless1551894de_fenseless
eventless1244604_e_ventless
fernless1136064fer__n_less
friendless1442544_friendless
nerveless1243934ner__veless
paneless102611764___paneless
parentless1244454par_entless
peopleless1441914peop_leless
purposeless1551474purposeless
relentless1043704re_lentless
servantless1451544servantless
spineless1136134__spineless
suspenseless1381704suspenseless
talentless1042804t_alentless
tapeless10218644t_ap__eless
teethless1243704te__ethless
tenantless1043054te_nantless
tenpences1346544tenpen_ce_s
tenseness947114tensen__ess
tensenesses1147614tensenesses
tentless8229844t___entless
tercelets1144814ter__celets
terebenes1146064ter_ebene_s
termless1036234ter___mless
terpene92310864terpen__e__
terpenoids1353584terpen_oids
terpineols1252074terpine_ols
terpinols1143734terpinol__s
terrenely1243854terrenel__y
terrenes82212604terren__e_s
terrorless1043104ter_rorless
textureless1851524textureless
threadless1442474thr_eadless
tireless82510264tir___eless
toneless8610394t___oneless
traceless11228644t_r_aceless
treadless1036004t_r_eadless
treponemes1453014treponeme_s
truceless11235394t_r_uceless
trueness838694t_ruen__ess
truenesses1039314t_ruenesses
tuneless837914t___uneless
weaponless1542004weapon_less

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819518.72017066.4
3Display Results51510.0301700.0
 (SQL Overall)178691519.17319480.1
 
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.