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

383 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
goblins103924(None) 
goblin939501goblin_
ablins8316192_ablins
aiblins9311472aiblins
bobbins103410342bobbins
codlins104116242codlins
colins85229042co_lins
collins93419832collins
dobbins12379532dobbins
doblons1037042doblons
gabling113514542gabling
globins10278952glob_ins
globulins1244172globulins
goalies8316022goalies
goaling93515332goaling
gobans94412042gob_ans
gobbing132910702gobbing
gobbling14257532gobbling
gobies95418062gob_ies
goblets103210182goblets
godling103513402godling
godlings11367492godlings
gosling93312402gosling
goslings10297552goslings
moulins9312702moulins
oodlins83210512oodlins
poplins11313152poplins
robbins112811062robbins
robins83617452rob_ins
ablings1038743_ablings
ambling121411793ambling
anilins7416793anilins
berlins93216013berlins
bins66548253__b_ins
blains84516373__blains
blin67228173__blin_
blind86319323__blind
blinds95111613__blinds
blini75519273__blini
blinis85313683__blinis
blink115720143__blink
blinks124613573__blinks
blips95615783__blips
bliss75616913__bliss
bobbies103714563bobbies
bobbin93410733bobbin_
bobbing113113193bobbing
bobbling12238643bobbling
bobolink1644493bobolink
bobolinks1742493bobolinks
bodkins1438313bodkins
boffins15329073boffins
boiling103819673boiling
bolling103820883bolling
botulins1047063botulins
boudins10311313boudins
bowfins15267703bowfins
bowline123613113bowline
bowlines133211623bowlines
bowling133916493bowling
bowlings14408753bowlings
brins75533973__brins
cabins104418923cab_ins
cabling124017553cabling
caplins113515993caplins
carlins93921923carlins
catlins93818843catlins
coalbins1237083coalbins
coaling103722823coaling
cobbling15248803cobbling
cobias104014993cob_ias
cobles104622883cobl_es
cocains111313923cocains
cochins141413103cochins
codeins103715483codeins
codlin94516443codlin_
codling114418953codling
codlings123110103codlings
coffins153110193coffins
coiling103723453coiling
coins75834553co__ins
cojoins1638993cojoins
colics104219903co_lics
colies84837053co_lies
colin76231693co_lin_
collies94326583collies
colons86028683co_lons
complins14313113complins
conins84327233co_nins
coolies93824963coolies
cooling103422573cooling
cortins92421333cortins
coulis84018763couli_s
cousins9516003cousins
covins114618063co_vins
cowling134017423cowling
cowlings14359783cowlings
cyclins1438303cyclins
cymlins1436693cymlins
dobbies124113063dobbies
dobbin11339523dobbin_
dobies94422093dob_ies
doblas93812293dobl_as
doblon938013doblon_
doblones1136763doblones
dobsons1036203dobsons
doilies84017363doilies
doling84923133do_ling
dollies83620983dollies
dolling93817373dolling
domains10510873domains
doolies83920713doolies
dormins10311273dormins
doubling1238153doubling
doylies114512573doylies
dubbins12358803dubbins
dunlins849553dunlins
eosins64419163eo_sins
fabling133413623fabling
fibrins1238643fibrins
foaling113515843foaling
fobbing153410273fobbing
foiling113317653foiling
foins85523383fo__ins
folios93915463fo_lios
follies103618943follies
follis93113903folli_s
fooling113117373fooling
fouling113315373fouling
foulings12327943foulings
fowling143713113fowling
fowlings15377243fowlings
gabbing133512033gabbing
gabbling14238073gabbling
gabies93820733gab_ies
gabions102410053gabions
gables94222333gabl_es
gaboons10289903gaboons
gains65729513g__ains
galleins9258693galleins
gallies84122713gallies
galling93921963galling
gallons83015953gallons
gambling14218963gambling
gamins94420053g_amins
gaoling93314653gaoling
garbling12249453garbling
garlics1038013garlics
gaskins123510773gaskins
gelling93219763gelling
ghiblis1353343ghibli_s
ghoulies1235393ghoulies
gibbing13339373gibbing
gibbons1234983gibbons
gibing103712353gib_ing
giblets103210423giblets
gibsons1045043gibsons
gillies84120963gillies
gilling93520383gilling
gins55543953g___ins
girlies83013703girlies
glans65125833g__lans
glens66519853g__lens
glias64618493g__lias
glims87417673g__lims
glint66830183g__lint
glints75714213g__lints
globin9309723glob_in_
globing113210003glob_ing
globoids1244413globoids
globulin1144193globulin_
glonoins955843glonoins
glycins1335563glycins
goading103112853goading
goalie7413163goali_e
goals65521293goal__s
goban84414073gob_an_
gobang10376703gob_ang
gobangs11385833gobangs
gobbets12327643gobbets
gobblers13308343gobblers
gobbles123512583gobbles
gobioids1243873gobioids
goblet93219483gobl_et
goboes95914443gob_oes
gobony1236913gob_ony
gobos86219383gob__os
gobs76935573gob___s
godding113911943godding
godless938403godless
godlier938893godlier
godliest1039453godliest
godlike1387563godlike
godlily1235343godlily
godliness1136593godliness
godowns1234673godowns
godsons966663godsons
godwits1234133godwits
goggling10246283goggling
goglets9379783goglets
going75218493go__ing
goings84911523go__ings
golds75421313go_l_ds
golems939323go_lems
golfing12368943golfing
golfings13304873golfings
golfs95616103go_l_fs
gombeens1342703gombeens
gonging103713033gonging
gonifs104310133go_nifs
goodies93516993goodies
goofing123510633goofing
googlies1086763googlies
goonies83618333goonies
goons65326773go__ons
goosing93314083goosing
gorblimy1641503gorblimy
gorging102611363gorging
gorgons938853gorgons
gorhens1137183gorhens
goring84119573go_ring
gorming112810833gorming
gossans836783gossans
gossips1035903gossips
gothics1336123gothics
gouging103410703gouging
governs1136103governs
gowans105512293go_wans
gowning12258833gowning
gowns95115103go__wns
gradins93416233gradins
grains74223093g_rains
graplins1148263graplins
gratins84119183gratins
gremlins1136053gremlins
grins65427223g__rins
groins73917203g_roins
growling1348163growling
guanins8810013guanins
guiling93214213guiling
gullies84717313gullies
gulling94019563gulling
gumline102810113gumline
gumlines11238573gumlines
guyline11258173guyline
guylines12236943guylines
gybing13355933gyb_ing
hobbies143813343hobbies
hobbing152811123hobbing
hobbits14317553hobbits
hobbling16227583hobbling
hobgoblins1851193hobgoblins
hoblike16158303hoblike
hoboing13309453hoboing
hoddins12289373hoddins
holies94630033ho_lies
holing104025073ho_ling
hollies103420813hollies
hotline10712353hotline
hotlines11811643hotlines
hotlink1476763hotlink
hotlinks1574193hotlinks
howling143413163howling
hyalins13229273hyalins
inulins7311493inulins
iodins74216523io_dins
jobbing19279013jobbing
jobless16237563jobless
joins125818413jo__ins
jollies143516273jollies
kaolins1139363kaolins
lins47059053___lins
lobbies113612463lobbies
lobbing123110913lobbing
lobefins1344823lobefins
lobelias1047203lobelias
lobeline1039963lobeline
lobelines1138563lobelines
logins77820643lo_gins
loins56728423lo__ins
lollies73116923lollies
lolling83415783lolling
lomeins969483lomeins
marlins93420473marlins
merlins93015813merlins
mobbing14299703mobbing
mobiles112813123mobiles
moiling103417663moiling
molies84429513mo_lies
moline84422033mo_line
mollies93420233mollies
moulin8313283moulin_
muslins9312213muslins
myelins1237353myelins
nobbling13228273nobbling
nobles83319723nobl_es
noggins9288453noggins
nubbins11268023nubbins
obelias9279033_obelias
obias76116863_ob_ias
obis66226843_ob_i_s
obits74617553_ob_its
oblige937653_oblige
obliges1037143_obliges
oblong935383_oblong
oblongs1033533_oblongs
obtains939163_obtains
ogling83211883_ogling
oiling74925313_oiling
oleins6313523_oleins
olios54520853_o_lios
online6315843_online
opsins8411713_opsins
orcins83313433_orcins
orlons6411013_orlons
orpins83614163_orpins
oxlips1544433_oxlips
paulins9312613paulins
poblano1145093poblano
poblanos1244993poblanos
polies84034583po_lies
poling93526503po_ling
polios84019723po_lios
polis74731163po_li_s
pollens93713303pollens
polling102920383polling
pooling103219093pooling
poplin10413483poplin_
postins93721203postins
potline91015233potline
potlines10714213potlines
publics13207143publics
purlins93415423purlins
rabbins112811343rabbins
ratlins73615583ratlins
robbin103611183robbin_
robbing123313213robbing
robin74820283rob_in_
robing93618003rob_ing
robles85321693robl_es
roiling83220453roiling
rolling83620413rolling
rollings9419953rollings
rosins64521863ro_sins
sabins85521983sab_ins
sibling10814423sibling
siblings11108123siblings
simlins9311843simlins
sobbing127612883sobbing
soiling83422323soiling
solans64122493so_lans
solids74116403so_lids
soling74226823so_ling
solions7513753so_lions
solons65120023so_lons
sozins15510793so_zins
subline9316893subline
sublines10315783sublines
tabling103216033tabling
tobies84521023tob_ies
tocsins939963tocsins
toiling83219023toiling
tolans64319273to_lans
toling73926123to_ling
tolling83418563tolling
tooling82918313tooling
toolings9248473toolings
topline92313183topline
toplines102412563toplines
towline102911543towline
towlines112610343towlines
toxins133314283to_xins
tubulins10106293tubulins
violins10311453violins
voling103918023vo_ling
wobblies15297233wobblies
wobbling16246923wobbling
woolens10398843woolens
woolies104117363woolies
yeelins1038813yeelins
yodling123610253yodling
yogins105114103yo_gins
yowling143610223yowling

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 Limit1340273836.73319906.0
3Display Results3833830.1402735.7
 (SQL Overall)1786913837.27924548.8
 
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.