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

141 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
butles8442391(None) 
bugles94822441bugles
bustles93816321bustles
butes714535871but_es
butle75023101butle_
butled94818601butled
butler84220031butler
butlers94518051butlers
buttes84822561buttes
bales76250082b_ales
bates75846342bat_es
bathes116524832bathes
battles94517682battles
baubles113611862baubles
beetles9312082beetles
belles85325992belles
betels84515062betels
bibles104617642bibles
biles75542142b_iles
birles84920642birles
bites75641172bit_es
bogles95020832bogles
boles75448602b_oles
botels84815802botels
bottles94216272bottles
boucles113113002boucles
boules84925972boules
boulles93114122boulles
brutes86118682brut_es
bubales113513342bubales
bubbles104315962bubbles
bubkes144612622bubkes
buboes104513992buboes
buckles153416092buckles
buddles113913072buddles
budges104820132budges
budless1038872budless
bugle84721942bugle_
bugled104918132bugled
bugler94717722bugler
buglers105115322buglers
buhls105111802buhl_s
builds9378492builds
bulbs96016932bu_lbs
bulges95919322bulges
bulks115920612bu_lks
bulled94626492bulled
bullet84528612bullet
bullets93516392bullets
bullies94121892bullies
bulls75629572bu_lls
bumbles134016842bumbles
bundles103515772bundles
bungles104116762bungles
bupkes144811482bupkes
burbles114916802burbles
burgles105615962burgles
buries84633272buries
burkes124421312burkes
burled94825382burled
burler84723832burler
burlers94120272burlers
burlesk1335462burlesk
burley114715752burley
burleys12479672burleys
burls74228852burl_s
burses84425512burses
buses75936012bu_ses
bushes115226112bushes
busies85525262busies
busses85023382busses
bustle84015482bustle_
bustled104011522bustled
bustler94012572bustler
bustlers104210622bustlers
butanes9312742butanes
butches144315362butches
bute66739672but_e_
butenes9313032butenes
buteo75419892but_eo
buteos84913412buteos
butlery12369422butlery
buts67247692but__s
butte74924292butte_
butted94722062butted
butter84724232butter
butters94521722butters
butties93217952butties
butts75824252but_ts
bututs8409422bututs
butyls1176752butyls
buzzes165011172buzzes
bytes105217492byt_es
cutes79438322cut_es
cuties84927362cuties
cutlas8313102cutlas
cutler84718032cutler
cutlers94217002cutlers
cutlet84924362cutlet
cutlets94113652cutlets
cuttles93613922cuttles
duties74921902duties
fugles104715782fugles
futzes184313112futzes
guiles73919282guiles
gules64831042gu_les
gutless82610712gutless
guttles83011932guttles
hurtles103913752hurtles
hustles103414172hustles
istles62814982istles
ixtles13217062ixtles
justles143311432justles
jutes125125132jut_es
lutes55836662lut_es
lutzes153711922lutzes
mules75034292mu_les
mutes75033782mut_es
mutules9311842mutules
nutlet64220562nutlet
nutlets74111252nutlets
outled74020342outled
outlet63728682outlet
outlets73616362outlets
outlies72421992outlies
pules74538812pu_les
putzes174212522putzes
rubles83921702rubles
rules55234252ru_les
rustles73416412rustles
rutiles74315842rutiles
sutler63718392sutler
sutlers73116972sutlers
titles63719922titles
tules54532792tu_les
tulles63218892tulles
turtles72914342turtles
tutees6514552tutees
utes45930882_ut_es
yules84521582yu_les
yutzes18408412yutzes

Search took 4 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 Filter178691825510.360496363.9
2DLD Change Limit825511412.59331836.1
3Display Results1411410.0463065.2
 (SQL Overall)1786911412.99959583.5
 
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.