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

153 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
subrents1031029(None) 
subrent9315081subrent_
brents84717272__brents
currents1038372currents
sorbents10279132sorbents
subagents1245002subagents
subgenus1145752subgenus
subjects19226532subjects
sublets92616702suble_ts
submenus1245902submenus
subnets92512082subne_ts
subpenas1246902subpenas
subrings11229882subrings
subsects12267902subsects
subsets92813102subse_ts
subtends1136172subtends
subtests1037532subtests
subtexts1744902subtexts
subtrends1244062subtrends
subvenes1339632subvenes
subverts1336972subverts
absents93510723_absents
ambients1246053ambients
audients946353audients
augments1137833augments
bents76033693__b_ents
brants85723053__brants
brens75823363__bren_s
brent75734133__brent_
brunts85215453__brunts
burets84321263bu_re_ts
burnets93813263bu_rnets
curets84922343cu_re_ts
currants1037933currants
current9313693current_
gerents82612923_gerents
gurnets84010793gu_rnets
hutments1345603hutments
jurants14379213ju_rants
labrets939363labre_ts
nutrients944423nutrients
parents93418123_parents
quitrents1843893quitrents
rents55935183___rents
rerents73319423_rerents
sabres85520863sabre__s
salients839563salients
sapients1037423sapients
sarments10311963sarments
scents85317023s__cents
secrets9311773secre_ts
segments1138903segments
sequents1756993sequents
serenes73222903s_erenes
serpents102410373serpents
silents73514493s_ilents
sirens65318153s_iren_s
sklents11348163s_klents
solvents1136763solvents
sorbent92915243sorbent_
sorbets93012513sorbe_ts
soubrette1143993soubrette
soubrettes1243963soubrettes
spirants1088283spirants
splents93912133s_plents
sprent84522383s_prent_
sprints94113773s_prints
starets73515923stare_ts
stents65019453s__tents
streets73312613s_treets
strunts7429543s_trunts
students954683students
styrenes11116623styrenes
subagent1147913subagent_
subareas1038623subare_as
subbings13238483subbings
subbreeds1443573subbreeds
subcells1246283subcells
subcenter1347073subcenter
subcenters1446163subcenters
subcults1246933subcults
subdeans1137203subdeans
subdebs1236483subde_bs
subdepots1443163subdepots
subducts13106093subducts
subedits1146713subedits
subentry1344693sub_entry
suberect12410873suberect_
suberins10315093suberins
suberous10311793suberous
subers85722643sub_e_rs
subgenre1144873subgenre
subgenres1245533subgenres
subheads1496533subheads
subject18258633subject_
sublet82827243suble_t_
sublines10315783sublines
sublots92410913sub_lots
submenu1148363submen_u
submits1139753sub_mits
subnet82520933subne_t_
suborners1146313suborners
suborns939493suborn_s
subparts1246903subparts
subpena1136673subpen_a
subplots1255773subplots
subpoenas1344413subpoenas
subraces12313033subraces
subring104116263subrin_g
subrules1039723subrules
subsect112611843subsect_
subsense1046963subsense
subsenses1147473subsenses
subseres10312423subseres
subset83122583subse_t_
subsists1037993subsists
subteens1037423subteens
subtenants1244553subtenants
subtend1037103subten_d
subtest9513963subtest_
subtext1647653subtext_
subtones10311383subtones
subtracts1346363subtracts
subtrend1145193subtren_d
subunits1046623subunits
subvene1238493subven_e
subvened1436423subvened
subvert12312893subvert_
subzones1947223subzones
sucres84218893sucre__s
suddens9308783sudden_s
suets55126103su__e_ts
suggests1044713suggests
suints64617783su__ints
sunbelts1044673sunbelts
sunkets113511283sunke_ts
sunsets72911573sunse_ts
supremes1238363supremes
supremos1245813supremos
sureness8912903su_reness
surest65026763su_rest_
surety93515013su_re_ty
surfeits1146223surfeits
surprints1145283surprints
surreys10489443surre_ys
suspects1254863suspects
suspends1145143suspends
syrens94911993s_yren_s
torrents838143torrents
turrets73010673turre_ts
unrent63219783_unrent_
unrests7229463_unrests
vibrants1345913vibrants

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.403443402.0
2DLD Change Limit1461621537.78318779.6
3Display Results1531530.0463326.1
 (SQL Overall)1786911538.23221706.9
 
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.