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

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

80 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
blisters10401508(None) 
bisters93922611b_isters
blasters104116141blasters
blister94415311blister_
blistery13418711blistery
blusters104413891blusters
glisters93912601glisters
klisters123910481klisters
listers74026531_listers
baiters94619302bai_ters
balusters1136642balusters
banisters11189472banisters
basters94930302b_asters
bilsteds1134272bilsteds
bister84922762b_ister_
bistres94017212b_istres
biters83925242b_i_ters
bitters94920362b_itters
blaster94017302blaster_
blatters104414092blatters
bleaters103412322bleaters
blessers10277632blessers
blighters1555742blighters
blinders113911142blinders
blinkers14388502blinkers
blisses94911512blisse_s
blistered12167682blistered
blites84721212bli_te_s
blithers134711232blithers
blitzers19417152blitzers
bloaters103311022bloaters
blotters104110982blotters
blurters10348372blurters
blushers133911292blushers
bluster94215312bluster_
blustery13368002blustery
boasters103915662boasters
bolsters103712452bolsters
boosters104013442boosters
bursters1038982bursters
busters94724132b_usters
cloisters1137432cloisters
clusters102912402clusters
clysters13227842clysters
enlisters937112enlisters
filisters1237002filisters
flirters11337932flirters
flitters114312172flitters
flusters113811502flusters
glistens9366592glistens
glister84013342glister_
glitters93710542glitters
gristers94013402gristers
heisters113413132heisters
hoisters113513482hoisters
keisters123212042keisters
klister113410642klister_
lasters75627692_lasters
leisters83312822leisters
lifters104313782_lifters
linters73822632_linters
lispers94514322_lispers
listees73416672_listees
listels74212432_listels
listens74014132_listens
lister64527252_lister_
liters65429882_li_ters
litters73422572_litters
lusters73921442_lusters
meisters103313842meisters
misters93927512_misters
oldsters996732oldsters
plaisters1137812plaisters
plasters103518132plasters
roisters83615552roisters
sisters73721592_sisters
slitters84014132slitters
twisters11268172twisters
ulsters72711982ul_sters
waisters113811522waisters

Search took 5 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 Filter1786911210590.466383457.1
2DLD Change Limit121059803.56333976.7
3Display Results80800.0461739.1
 (SQL Overall)178691804.07543850.6
 
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.