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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

110 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
izzard1513524(None) 
gizzard17114201gizzard
izzards16143961izzards
blizzard1942302blizzard
buzzard1844272buzzard
gizzards18133262gizzards
hazard1938402hazard
inward10310332inward
izar136616012i_zar_
izars145112932i_zars
lizard16369232lizard
mazard1838762mazard
mazzard1844462mazzard
vizard19458852vizard
wizard19377712wizard
aboard9312613aboard
afeard1058263afeard
airward1148133airward
award97118043_award
bard75648863__bard
bayard124411663bayard
bazar163816003bazar_
bazars174613113bazars
beard86024963_beard
blizzards2042013blizzards
blizzardy2351343blizzardy
board85523003_board
boyard125411283boyard
briard94311293briard
buzzards1943613buzzards
canard9314763canard
card710245873__card
chard116124743_chard
coward12411673coward
czar156013133_czar_
czars164812913_czars
diehard1237053diehard
discard11310213discard
dizzied17236133dizzied
dotard839053dotard
echard1249223echard
fard85639063__fard
fizzed18369443fizz_ed
fizzer17369383fizzer_
fizzers18357003fizzers
fizzled19357273fizzled
gazar154612983gazar_
gazars164811553gazars
guard74415543_guard
hard85443503__hard
hazards2037463hazards
heard95222753_heard
hoard94918313_hoard
holard10410573holard
huzzaed1943103huzzaed
iliad64613463ilia_d
imbark14347863imbark
impark14287073impark
impart102715143impart
inarm7314423i_narm
inboard1037063inboard
infare9313083infare
inlaid7310143inlaid
inland7310313inland
innards837153innards
invar839513invar_
invars9310003invars
inwards1138343inwards
island738533island
lard56742003__lard
lazar144113643lazar_
lazars153812393lazars
liard65418593_liard
lizards17427613lizards
lyard95113213_lyard
mazards1937703mazards
mazzards1943943mazzards
mizzled18327633mizzled
nard56634453__nard
niggard1044943niggard
onward1039053onward
pard76441323__pard
petard95013803petard
pizza1538183pizza__
pizzas1646983pizza_s
pizzaz1565443pizza_z
pizzazz0243023pizzazz
regard85215773regard
retard75018933retard
reward106017643reward
ritard74812083ritard
sard55344243__sard
shard96125963_shard
sizar145214993sizar_
sizars154812623sizars
sizzled16367883sizzled
sward94221463_sward
tabard9313333tabard
toward10311063toward
tzar136315373_tzar_
tzars144914273_tzars
upward12147163upward
vaward13498723vaward
visard103910123visard
vizards20377263vizards
ward86542253__ward
wizards20326403wizards
yard85633253__yard
zarf166929123__zarf
zizzled15315853zizzled

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127161105.09622118.5
3Display Results1101100.0462391.3
 (SQL Overall)1786911105.53232301.3
 
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.