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

130 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
goliard93607(None) 
goliards1045131goliards
bollard103210502bollard
collard103712922collard
foliar93210972foliar_
galliard10125752galliard
goalward1343492goalward
goldarn944382goldarn
goliardic1351942goliardic
goliath1145932goliath
holard10410572hol_ard
liard65418592__liard
pollard103511142pollard
poniard1037582poniard
biliary1238213biliary
billiard1145873billiard
board85523003bo__ard
bolar75123473bol_ar_
bolivar1244853bolivar_
bolivars1344973bolivars
bollards11339153bollards
bombard1437333bombard
boyard125411283bo_yard
briard94311293_briard
ciliary1247923ciliary
coalyard1444093coalyard
colead94114643colea_d
collar83816173collar_
collards113310193collards
collared113211143collared
collars93816573collars
costard104113353costard
coward12411673co_ward
dollar74110983dollar_
dollars83311023dollars
dotard839053do_tard
dullard936603dullard
eolian6312593eolia_n
folia83618933folia__
foliage1147533foliage
foliaged1344673foliaged
foliate10513533foliate
foliated1249913foliated
folioed1138033folioed
forward1438293forward
foulard11257283foulard
gabbard1336553gabbard
galliards1194543galliards
gelid74916983geli__d
gird65424993g__i_rd
gizzard17114203gizzard
glad65624013g_l_a_d
glair65313553g_lair_
glaire74411293g_laire
glaired9387743g_laired
glairs75211333g_lairs
glairy10448273g_lairy
gland75217713g_l_and
glare65222953g_l_are
glared84715193g_l_ared
glary96018543g_l_ary
glia56423153g_lia__
glial66715433g_lia_l
glias64618493g_lia_s
glided94513903g_lided
glimed105312283g_limed
goad66830983go__a_d
gobioid1146023gobioid
godlier938893godlier_
goitre7349003go_itre
gold65430163gol___d
goldarns1043593goldarns
golder84417603golder_
goldurn943333goldurn
golfed11569763gol_fed
golfer104411183golfer_
golfers114410083golfers
goliaths1244223goliaths
gonad75216053go_na_d
gonia64117533gonia__
gooier73516213gooier_
gorier73719373gorier_
gormand1157453gormand
gourd71011903go__urd
guard74415543g__uard
guisard954203guisard
gular6314833gul_ar_
gurnard944773gurnard
halliard12125963halliard
halyard1476973halyard
hoard94918313ho__ard
holards1148433hol_ards
holier94921623holier_
hollaed11359853hollaed
holland11349473holland
iliad64613463_ilia_d
laird65417793__laird
laniard868523laniard
lard56742003__l_ard
liar47229683__liar_
liards75212613__liards
liars54723163__liars
lizard16369233__lizard
lyard95113213__lyard
mallard10310273mallard
miliary1249463miliary
milliard1147033milliard
molar75223093mol_ar_
molars85517323mol_ars
olivary1345163_olivary
onward1039053_onward
pochard1537363pochard
polar75623453pol_ar_
polars84419353pol_ars
poleward1455943poleward
policed123212233policed
polkaed1435323polkaed
pollards11299523pollards
poniards1145823poniards
poulard10299733poulard
soland75115043sol_and
solar55927343sol_ar_
solid65025083soli__d
solidary1245103solidary
solitary1146503solitary
tolar55524113tol_ar_
tolars64817943tol_ars
topiary1245813topiary
toward10311063to_ward
volar86917413vol_ar_

Search took 10 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.423422437.4
2DLD Change Limit1340271308.54615683.0
3Display Results1301300.0462826.1
 (SQL Overall)1786911309.01519821.5
 
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.