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

145 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
gourmet105920(None) 
gourmets1144151gourmets
gorget87123862go_rget
gormed105013832go_rmed
gourde8107932gourde_
gourdes9109382gourdes
grummet12298872grummet
gurnet74920872g_urnet
armet76739453__armet
bouquet18288263bouquet
bourne83714093bourne_
bournes93615023bournes
bourree91311343bourree
bourse84414333bourse_
bourses94014303bourses
buret77444013_bur_et
burnet84326173_burnet
cermet10321153_cermet
comet95946073co__met
cormel103815603co_rmel
cornet84436733co_rnet
corset85636223co_rset
corvet114626933co_rvet
couplet114717943couplet
courant9317973courant
courier93617873courier
course85117773course_
coursed104113603coursed
courser94114803courser
courses94218893courses
court75532763cour__t
courted103514913courted
courter94516463courter
curet75447643_cur_et
curvet114720243_curvet
doormat1059073doormat
doormen1036753doormen
dormer94415893do_rmer
doublet103914033doublet
dourer74215273dour_er
dourest8312943dourest
forget106326393fo_rget
format113021353fo_rmat
forme105225993fo_rme_
formed125021173fo_rmed
formee113919943fo_rmee
former114221403fo_rmer
formes114623713fo_rmes
fumet105630223_fu_met
furmety1534813_furmety
garget84327273g_arget
garment10315233g_arment
garnet73928413g_arnet
garret74426553g_arret
gaumed104610323gau_med
germen9612313g_ermen
glume85120463glu_me_
glumes94516813glu_mes
glummer12417983glummer
glummest13235563glummest
gobbet114214443go_bbet
goblet93219483go_blet
godet7530043go__det
goglet84618583go_glet
gomer85220653go__mer
goodmen1135623goodmen
gore55744963go_r_e_
gored75227083go_r_ed
gores65740373go_r_es
gorge76423893go_rge_
gorged95016983go_rged
gorger86116983go_rger
gorges85321893go_rges
gorgets94711783go_rgets
gorhen1038893go_rhen
gorier73719373go_rier
goriest82218743go_riest
gorm75529393go_rm__
gorms85619593go_rm_s
gorse65926813go_rse_
gorses74723293go_rses
gouge78220063gou_ge_
gouged96214593gou_ged
gouger86014363gou_ger
gouges86318693gou_ges
gourami1083803gourami
gouramies1294763gouramies
gouramis1184163gouramis
gourd71011903gour__d
gourds8108253gour_ds
gourmand1243263gourmand
gout56646003gou___t
goutier82612353goutier
goutiest93013883goutiest
greet65835323g__reet
grommet12268453grommet
grume86218163gru_me_
grumes94415553gru_mes
grummer12338783grummer
grummest13286363grummest
grummets13275033grummets
guglet84018223g_uglet
gullet74924833g_ullet
gummed123811663g_ummed
gummer114615453g_ummer
gunmen9348723g_unmen
gurge75419783g_urge_
gurged95513363g_urged
gurges84716863g_urges
gurglet94412033g_urglet
gurnets84010793g_urnets
gurney10429413g_urney
gusset7316433g_usset
hornet94926433ho_rnet
journey1734873journey
loured74617403lour_ed
maumet103518883mau_met
mourned1037763mourned
mourner938083mourner
normed95014543no_rmed
ormer75218373_o_rmer
ourie54027293_ourie_
outlet63728683_outlet
outset64027453_outset
plummet13278353plummet
poured95116743pour_ed
pourer84516043pour_er
roupet84218343rou_pet
sorbet83924073so_rbet
source8410673source_
sourced1038453sourced
sources9312173sources
soured74921863sour_ed
sourer63620213sour_er
sourest7515713sourest
torment9316173to_rment
toured74216153tour_ed
tourer64115073tour_er
tourist7313203tourist
tourney1036273tourney
turret63121853_turret
unmet74426393__unmet
wormed124314303wo_rmed
wormer114514913wo_rmer
worset96726583wo_rset

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.1561145455.1
2DLD Change Limit1340271456.78019768.0
3Display Results1451450.0463152.2
 (SQL Overall)1786911456.98225593.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.