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

157 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
trenails86984(None) 
renails74917261_renails
tenails73713921t_enails
toenails847211toenails
treenails945561treenails
trenail7410811trenail_
prevails1337662prevails
remails94714562_remails
renail65020762_renail_
resails74616742_resails
retails74718972_retails
tenail64516112t_enail_
toenail738782toenail_
trails64622512tr__ails
travails1146082travails
treenail846122treenail_
trefoils1145302trefoils
trendies9312212trendies
trendily1256442trendily
trysails1144162trysails
adrenals946313adrena_ls
agnails837003_agnails
arenas65021993arena__s
arsenals847743arsena_ls
aventails1244993aventails
bewails1277553_bewails
brails84621293br__ails
brantails1146313brantails
cremains1238693cremains
crenels93711013cren_els
denials84114133_denials
dentils84115583_dentils
derails84216393_derails
details84214043_details
drails74716953dr__ails
emails84412343__emails
entails7912823__entails
eternals8238953eterna_ls
foresails1247153foresails
frails93716473fr__ails
frenzies2037713frenzies
frenzily2343733frenzily
grails77518783gr__ails
greenmails1382783greenmails
gremials1136133gremials
grenades1038433grenades
hobnails1343303hobnails
irenics937833iren_ics
jezails2334163_jezails
lentils73912973_lentils
menials94015683_menials
nails55730403___nails
pencils113011773_pencils
pensils92811593_pensils
preboils1267293preboils
prenames12311643prenames
prevail1238243prevail_
rails55937403_r__ails
reals55038653_re_a_ls
reavails1134853_reavails
rebaits9312573_rebaits
reboils94111723_reboils
recalls92613623_recalls
recoils93814873_recoils
redials84416883_redials
redtails968003_redtails
refalls103312243_refalls
regains84316583_regains
remail85017123_remail_
remains94117913_remains
renailed92512803_renailed
renal55929503_rena_l_
renames92418053_renames
renigs74314593_ren_igs
renins64526453_ren_ins
rennins74013413_rennins
rentals74017473_rentals
reoils64516873_re_oils
repairs9319973_repairs
resail64418733_resail_
retail65522073_retail_
retains74522253_retains
serails73318363_serails
snails64816653__snails
stencils1046403stencils
taenias7311283taen_ias
tails55634193t___ails
teals56234133t_e_a_ls
tenable93214493t_enable
tenably122210453t_enably
tenaces92814513t_enaces
tenaille846813t_enaille
tenailles946323t_enailles
tenants7311013t_enants
tendrils946443t_endrils
tenias64720073t_en_ias
tennies73017973t_ennies
tennis64015303t_enni_s
tenpins9410073t_enpins
tensile72612733t_ensile
tenuis64213083t_enui_s
tepals85415043t_epa_ls
terais64023513t_erai_s
ternaries9311643ternaries
terrains8410323terrains
tertials8510073tertials
thenages12107483thenages
thenal92712423thena_l_
thenars10248523thena_rs
toenailed1043483toenailed
tonsils7310183t_onsils
topsails1075093topsails
tormentils1243773tormentils
traiks104013713tr__aiks
trail55126773tr__ail_
trains64725343tr__ains
traits65121983tr__aits
trannies8415013trannies
transits8313503transits
travail1036553travail_
trawls94412393tr__awls
treacle939973tre_acle
treacles1039703tre_acles
treacly1237093tre_acly
treadle8310103tre_adle
treadles939703tre_adles
treads74817923tre_a_ds
treaties8316983treaties
treats64821693tre_a_ts
trefoil1066063trefoil_
trehala1045953treha_la
trehalas1144883trehalas
trellis739873trelli_s
trenches133512603trenches
trendier937913trendier
trendiest1038423trendiest
trending103012833trending
trendoids1143943trendoids
trends75513543tren__ds
trepangs11205403trepangs
trepans92311593trepa_ns
tressels8367653tressels
trevally1446343trevally
trevallys1542213trevallys
trials64319883tr_ia_ls
tribals9610753triba_ls
triennials1043623triennials
trinal6516963trina_l_
trochils1388583trochils
tronas63816903trona__s
trunnels844513trunnels
trysail1044543trysail_
twenties1137503twenties
unnails738223_unnails
urinals7610263urina_ls
utensils8124963utensils
ventails1139823_ventails

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 Limit1461621576.87321266.1
3Display Results1571570.0632492.1
 (SQL Overall)1786911577.35924282.0
 
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.