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

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

55 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
barrenest114956(None) 
bareness10912812ba_reness
barrener1038342barrene_r
barrenness1243752barrenness
barrens94414322barren_s_
arbelest1049503_arbelest
arenes64928393_a_renes_
arrest63722633_arr__est
bareges105212033ba_reges_
barest85327693ba_r__est
bargees105415873barge_es_
barghest1447913ba_rghest
barguest1137163ba_rguest
barkiest144115153ba_rkiest
barmiest125212783ba_rmiest
barniest104815053ba_rniest
baroness101210063ba_roness
baronet91022213ba_rone_t
baronets101410913ba_ronets
baronnes1038553baronnes_
barrages11711093barrages_
barreled1137853barrele_d
barrels94514363barre_ls_
barren85317623barren___
barrenly1345423barren_ly
barres84427553barr__es_
barret84930493barr__e_t
barrets94917113barre_ts_
barrettes1149073barrettes_
bartends1136793bartends_
baseness10910943ba_seness
bizarreness2251733bizarreness
braveness14237763braveness
briefest1335893b_riefest
brownest1398893b_rownest
burriest102911213burr_iest
darnedest1145253darnedest
earnest7318733ea_r_nest
greenest9312623_greenest
larcenist1147323larcenist
largeness1038273largeness
narrowest1244293narrowest
rareness81112853ra_reness
renest64529713___renest
sarcenet10413313sarcene_t
sarcenets1146963sarcenets
sarsenet8412943sarsene_t
sarsenets946523sarsenets
serenest82717623_serenest
tarriest83215003tarr_iest
tarriness9229253tarriness
terrenes82212603terrenes_
warrener1136923warrene_r
warreners1236203warreners
warrens103810893warren_s_

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.423422437.4
2DLD Change Limit148641557.01321195.1
3Display Results55550.0163437.5
 (SQL Overall)178691557.45223978.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.