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

81 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
bristles101510431bristl_es
bristlier1144311bristlier
bristliest1245141bristliest
bhisties1339002bhist_ies
bristle91910102bristl_e_
bristled11187342bristl_ed
bristling1246662bristling
brittles10178652brittl_es
gristles9189202gristl_es
gristlier1044282gristlier
gristliest1154982gristliest
artistries1047253artistries
bailies94120203bai__lies
bastiles10313353b_astiles
beasties102514653beast_ies
beastlier1144203beastlier
beastliest1244663beastliest
bhistie1236773bhist_ie_
bialies93618413b_i_alies
billies93923503b_i_llies
bistres94017213b_ist_res
blasties102113633blast_ies
boiseries11411043boiseries
brasilins1146243brasilins
brassies103613533bras_sies
brattles10199333brattl_es
briberies1348333briberies
brickles162810283brickl_es
bricoles122610303bricol_es
bridles104114473bri_dl_es
brimstones1464383brimstones
brindles113710223brindl_es
brinies93317913bri__nies
brionies10310543bri_onies
brisances1345843brisances
brises84927613bris___es
brisling112410843bris_ling
brislings12236363bris_lings
brisses94314313bris__ses
bristly12178063bristl__y
bristols1046773brist_ols
britches15278683bri_tches
brittle9168603brittl_e_
brittled11186093brittl_ed
brittler10165983brittl_er
brittlest11146193brittl_est
brittling1235543brittling
brollies1039533br_ollies
bustles93816323b_ustl_es
bustlines11207353b_ustlines
christies1449263christ_ies
epistles1047783epistl_es
eristics10610193erist_ics
frostlines1345193frostlines
grislier935793gris_lier
grisliest1047353gris_liest
gristle8169223gristl_e_
gristliness1264003gristliness
grizzlies18123193grizzlies
istles62814983__istl_es
mislies92922283_mis_lies
priestlier1242883priestlier
priestliest13103583priestliest
prissies101712003pris_sies
pristanes11410433pristanes
prosties101421193prost_ies
rustles73416413_rustl_es
thistles1198233thistl_es
thistlier1243653thistlier
thistliest1344383thistliest
trestles83012553trestl_es
trisomies1147163trisomies
trusties82712853trust_ies
waistlines1343893waistlines
whistles14108213whistl_es
wrastles11328933wrastl_es
wrestles113310063wrestl_es
wristier1136863wrist_ier
wristiest1237753wrist_iest
wristlet1138643wristl_et
wristlets1244473wristlets

Search took 7 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.453394461.4
2DLD Change Limit148641816.28323657.6
3Display Results81810.0302700.0
 (SQL Overall)178691816.76626410.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.