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

126 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
trailless93596(None) 
tailless8239081t_ailless
braillers1135552braillers
brailles1039492braille_s
brainless1136402brainless
frailness1236542frailness
grainless1035892grainless
mailless10248582_mailless
rainless8129702_rainless
sailless82410372_sailless
tailles72516472t_aille_s
traceless11228642traceless
trackless15246722trackless
trailers82912922trai_lers
traitress944402traitress
tramless1037502tra_mless
trillers83613492tr_illers
aidless83612073__aidless
aimless93610813__aimless
airless73712043__airless
bractless1335543bractless
braille939713braille__
brailled1147193braille_d
brailler1036883braille_r
braillist1146193braillist
braillists1263663braillists
brakeless1544993brakeless
braless92910563bra__less
brandless1236123brandless
brimless1235273br_imless
coalless1038193coa_lless
drillers9429723dr_illers
dripless1135243dr_ipless
failles102914133_faille_s
frailest1139493frai_lest
frameless1435533frameless
frillers11349873fr_illers
fruitless1244163fruitless
gainless9117403_gainless
goalless935723goa_lless
graceless12226893graceless
gradeless11236703gradeless
grassless1034303grassless
grateless10277583grateless
graveless13226693graveless
grillers93810813gr_illers
grilles83715023gr_ille_s
hairless1157413_hairless
mealless10288363mea_lless
painless10108343_painless
railers74420663_rai_lers
raillery1134953_raillery
rankless12268233_rankless
rayless10239003_ra_yless
reinless8139433_reinless
ribless93410343_r_ibless
rilles64725503_r_ille_s
rillets74216153_r_illets
rimless9369363_r_imless
skilless12246763_skilless
soilless8279033_soilless
stainless9176493stainless
stairless9185623stairless
straitness1046293straitness
strapless1135793stra_pless
tableless1145023t_ableless
tackless14419483t_ackless
tactless10288463t_actless
tailers73720183t_ai_lers
taille63116923t_aille__
tailleur843303t_ailleur
tailleurs942803t_ailleurs
taintless935733t_aintless
tallest7317093t_a_llest
tallness837103t_allness
tameless10259903t_ameless
tankless12267823t_ankless
tapeless10218643t_apeless
taxless1436903t_a_xless
tearless848713tea_rless
tenailles946323tenaille_s
thankless1633203thankless
thawless1434083tha_wless
thrillers1244473thrillers
tieless72512563t__ieless
tillers73418743t__illers
tipless92610063t__ipless
toadless936313toa_dless
toolless836343t_oolless
trachles13311753trachle_s
trailed83415673trai_le_d
trailer73015393trai_le_r
trailhead1343423trailhead
trailheads1443063trailheads
trails64622513trai_l__s
trainees82712063trai_nees
trainers83114643trai_ners
traipses1036873traipse_s
traitoress1043623traitoress
tramplers13305883tramplers
tramples122610203trample_s
travelers12266773travelers
travellers1364663travellers
trawlers113310203tra_wlers
trawleys14284383tra_wleys
trawlnets1242843trawlnets
treadless1036003treadless
treeless839283tr_eeless
triflers113110213tr_iflers
trifles103814823tr_ifle_s
trigness968403tr_igness
trilled84116313tr_ille_d
triller74215893tr_ille_r
trills64319853tr_ill__s
trimness1067563tr_imness
triolets83410143tr_iolets
triples94616873tr_iple_s
triplets103510263tr_iplets
troiluses944553troiluses
trollers83211213tr_ollers
trolleys11315693tr_olleys
truceless11235393truceless
trustless955953trustless
truthless1244033truthless
tuilles72411923t_uille_s
twigless1293663t_wigless

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.1601116818.8
2DLD Change Limit1486411267.31020333.9
3Display Results1261260.0632000.0
 (SQL Overall)1786911267.53323721.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.