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

71 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
bustler9401257(None) 
buster84726491bust_er
bustier93916151bustier
bustle84015481bustle_
bustled104011521bustled
bustlers104210621bustlers
bustles93816321bustles
butler84220031bu_tler
hustler103410751hustler
rustler73512341rustler
baster85333602bast_er
battler94113382battler
beetler938042beetler
bister84922762bist_er
bluster94215312blust_er
bottler94211882bottler
bubbler103611782bubbler
buckler154112032buckler
bugler94717722bu_gler
bumbler134013232bumbler
bundler104011722bundler
bungler104611482bungler
bunter85020382bunt_er
burbler114412422burbler
burler84723832bu_rler
burster9310292burst_er
busheler1374762busheler
busher114922202bus_her
bushier123712812bushier
busier85219722bus_ier
busker125517832bus_ker
busted95123152bust_ed
busters94724132bust_ers
bustiers103810052bustiers
butle75023102bu_tle_
butled94818602bu_tled
butlers94518052bu_tlers
butlery12369422bu_tlery
butles84423912bu_tles
butter84724232bu_tter
cutler84718032cu_tler
duster74919722dust_er
dustier83814132dustier
fustier104213932fustier
gustier83813862gustier
guttler8369162guttler
hostler103411022hostler
hustle93113992hustle_
hustled113210132hustled
hustlers11349202hustlers
hustles103414172hustles
jostler14288222jostler
juster134617012just_er
justle133211582justle_
justled15338092justled
justles143311432justles
luster64023672lust_er
lustier73813502lustier
muster84724522must_er
mustier94017962mustier
nestler73510452nestler
ostler63312192_ostler
ouster64223732oust_er
rustier74416362rustier
rustle63615412rustle_
rustled83311322rustled
rustlers8339852rustlers
rustles73416412rustles
subtler92910852subtler
sutler63718392su_tler
turtler72610322turtler

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 Filter1786911076710.360496363.9
2DLD Change Limit107671713.37331921.4
3Display Results71710.0332151.5
 (SQL Overall)178691713.76647448.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.