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 “brants” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

142 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
brants8572305(None) 
bracts105617771bracts
brands95118941brands
branks124817381branks
brans75437431bran_s
brant74742171brant_
brats75336011bra_ts
brents84717271brents
brunts85215451brunts
grants73722471grants
rants55935341_rants
alants67722022alants
ants47243472__ants
bahts105617802b_ahts
baits76630582b_aits
bands85233432b_ands
banes74945582b_anes
bangs85627782b_angs
banks115527902b_anks
banns75321232b_anns
bans66555142b_an_s
banty106624002b_anty
barns76335142barn_s
basts75936932b_asts
bats66962332b_a_ts
batts76727562b_atts
beanos85516512beanos
beans75734692bean_s
beasts84519722beasts
beats76042242bea_ts
beauts86015282beauts
bents76033692b_ents
bezants1877342bezants
bhangs12449662bhangs
bints76130182b_ints
bionts8612392bionts
blanks124112892blanks
blasts85116772blasts
blats75132502bla_ts
blunts84512892blunts
boarts84716872boarts
boasts85017922boasts
boats75635152boa_ts
boranes93720402boranes
braces108427772braces
brachs134415752brachs
bract96332722bract_
brads85528292bra_ds
braes75735052bra_es
brags85625102bra_gs
braids95015692braids
brails84621292brails
brains85125472brains
brakes124923122brakes
bran65740382bran__
branch134014782branch
brand85124492bran_d
brandy124712062brandy
brank115222282bran_k
branny115111832branny
bras65746452bra__s
brass75428022bra_ss
brat66055542bra_t_
bratty1159682bratty
bravas114913322bravas
braves115524082braves
bravos114711392bravos
brawls115214332brawls
brawns115614082brawns
braws106425192bra_ws
brays106723112bra_ys
brazas175812432brazas
brazes175522192brazes
breasts939702breasts
brens75823362bren_s
brent75734132brent_
brines85028852brines
brings94618432brings
brinks124616312brinks
brins75533972brin_s
brits76433082br_its
britts84813442britts
broncs101611152broncs
bruits85714452bruits
brunets9419552brunets
brunt75728752brunt_
bruts75922952br_uts
bunts75729802b_unts
burans85019302buran_s
bwanas1157442bwanas
byzants2153222byzants
cants77036942_cants
chants115020392chants
crafts115312742crafts
cranes84330752cranes
cranks125015312cranks
drafts105012532drafts
drats66628372dra_ts
errants7410642errants
francs114112192francs
franks134912732franks
frats86829672fra_ts
fronts94415792fronts
giants74713502giants
grafts105013252grafts
grands84218242grands
grans64832542gran_s
grant64840022grant_
grunts75511852grunts
hants86335402_hants
jurants14379212jurants
krafts13438852krafts
kraits104912202kraits
krauts10418512krauts
orangs74116032orangs
pants76536922_pants
plants84921802plants
prangs94816232prangs
pranks124814722pranks
prats76333392pra_ts
prints84320102prints
quants153614142quants
rafts87820632_rafts
rands65930452_rands
ranis55235832_ranis
ranks95225732_ranks
rant45864682_rant_
rats46260372_ra_ts
rents55935182_rents
runts55927632_runts
scants85219722scants
slants64819082slants
tracts85019072tracts
traits65121982traits
tranks104017762tranks
tranqs155210312tranqs
trans54933042tran_s
truants738162truants
tyrants1037452tyrants
vibrants1345912vibrants
wants87932212_wants
wrangs104611912wrangs

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 Filter178691825511.453122980.7
2DLD Change Limit825511426.31013082.6
3Display Results1421420.0334303.0
 (SQL Overall)1786911427.79622920.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.