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

90 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
butleries1171007(None) 
butteries11711761butteries
cutleries1179211cutleries
batteries11615112batteries
buggeries1347082buggeries
butcheries1745072butcheries
butlers94518052butler__s
butterier1177452butterier
butteriest1276882butteriest
fulleries1248722fulleries
adulteries1145623adulteries
arteries8321483art_eries
bakeries14312193b_akeries
batterie10711533batterie_
beaneries11310903beaneries
belfries1336983b_elfries
bibberies1297133bibberies
binderies12311683binderies
bitcheries1745903bitcheries
bobberies12107893bobberies
boiseries11411043boiseries
booteries11312773booteries
botcheries1746053botcheries
boweries13312293b_oweries
braveries1439103braveries
breweries1447583breweries
briberies1348333briberies
buglers105115323bugler__s
bullbrier1343683bullbrier
bullbriers1442383bullbriers
bulletins1146333bulletins
bullies94121893bu_l_lies
burglaries1344193burglaries
buries84633273bu___ries
burlers94120273burler__s
bursaries1157643bursaries
bustlers104210623bustler__s
butenes9313033but_e_nes
butler84220033butler___
butlery12369423butler__y
butles84423913butl___es
buttered112712623butter_ed
butterflies1652653butterflies
buttering122312523buttering
butterless1244193butterless
butters94521723butter__s
butties93217953but__ties
butylenes1444413butyle_nes
butyrins1345423but_yrins
catteries11815523catteries
cauteries11615393caut_eries
celeries10316313_celeries
coteries10422703cot_eries
cutcheries1745083cutcheries
cutlers94217003cutler__s
cycleries1647033cycleries
duperies11312813du_peries
eateries8324313eat_eries
fooleries1248743fooleries
galleries10311713galleries
gunneries1047043gunneries
helleries122611683helleries
juggleries1942803juggleries
lotteries9311073lotteries
mummeries1247243mummeries
niteries8318383nit_eries
nunneries947113nunneries
nurseries948013nurseries
outcries10313573out_cries
outlawries1382883outlawries
outlies72421993outl__ies
outserves12147373outserves
outwearies1345353outwearies
pedleries1298783pedleries
potteries11313593potteries
pufferies1745203pufferies
putrefies1444663putrefies
queries16315873qu__eries
rifleries1247683rifleries
ruderies9311333ru_deries
sculleries1244833sculleries
sealeries9313133sealeries
subseries11312933subseries
subtleties1245353subtleties
surgeries10311363surgeries
sutlers73116973sutler__s
turneries948493turneries
tusheries1246893tusheries
tutelaries1043963tutelaries
voleries11313233_voleries

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.420425454.8
2DLD Change Limit148641907.33020278.4
3Display Results90900.0461956.5
 (SQL Overall)178691907.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.