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

74 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
buzzard184427(None) 
buzzards1943611buzzards
blizzard1942302blizzard
bustard10389722bustard
buzzed17408472buzz_ed
buzzer16379112buzzer_
buzzers17347172buzzers
buzzword2242182buzzword
gizzard17114202gizzard
huzzaed1943102huzzaed
izzard15135242_izzard
mazzard1844462mazzard
bard75648863b___ard
bastard103012423bastard
bayard124411663b_ayard
bazaar17306403bazaar_
bazaars18275883bazaars
bazar163816003b_azar_
bazars174613113b_azars
beard86024963b__eard
bedward1497473bedward
beeyard1335523beeyard
bezoar1736913bezoar_
bezoars1836793bezoars
bezzant1746893bezzant
blizzards2042013blizzards
blizzardy2351343blizzardy
board85523003b__oard
bollard103210503bollard
bombard1437333bombard
boyard125411283b_oyard
briard94311293b_riard
bulbar1039583bulbar_
bulwark1645213bulwark
burd75534263bu___rd
bursar85413253bursar_
bursars94510893bursars
bursary12397583bursary
busbar1038453busbar_
busbars1138153busbars
bustards11308513bustards
buzz146617803buzz___
buzzcut1942473buzzcut
buzzes165011173buzz_es
buzzing18186543buzzing
buzzwig2141993buzzwig
buzzwords2351713buzzwords
custard10389973custard
dullard936603dullard
fuzzed18479253fuzz_ed
gizzards18133263gizzards
guard74415543gu__ard
guisard954203guisard
gurnard944773gurnard
guzzled17326263guzzled
hazard1938403_hazard
huzza1646093huzza__
huzzah2044423huzza_h
huzzahed2341503huzzahed
huzzahs2143083huzzahs
huzzas1735863huzza_s
izzards16143963_izzards
lizard16369233_lizard
mazard1838763_mazard
mazzards1943943mazzards
mustard10359533mustard
muzzled18267753muzzled
nuzzled16276393nuzzled
outward11811403outward
puzzled18286653puzzled
sunward1137653sunward
upward12147163_upward
vizard19458853_vizard
wizard19377713_wizard

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 Filter1786911340270.406440125.6
2DLD Change Limit134027746.84319586.0
3Display Results74740.0302466.7
 (SQL Overall)178691747.27924548.8
 
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.