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

165 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
goniff1340889(None) 
gonif94320921goni_f
goniffs14473901goniffs
gonifs104310131gonifs
gliff124915662g_liff
gonef95221292gon_ef
gonefs10439872gonefs
gonia64117532goni_a
gonion73612832gonion
gonium949802gonium
gonof95218652gon_of
gonofs10459862gonofs
griff124416462g_riff
pontiff1547902pontiff
sniff113915862_sniff
agonic93515143agoni_c
agonies83016623agonies
agonise83112693agonise
agonist82615403agonist
agonize172911403agonize
biff125026893__biff
boff124727333bo__ff
bonier84321993bonier
boning94223293boning
bonita8312943bonita
bonito8313433bonito
cliff135917133_cliff
codify1537163codify
coff126930783co__ff
coif96337913co_i_f
coiffe1447043co_iffe
coifs105718703co_ifs
confit113316403confit
coni65534803coni__
conic95329793coni_c
conics103920593conics
conies84338593conies
conifer123212643conifer
conin76232723coni_n
conine84528553conine
coning94331823coning
conins84327233conins
conium10415313conium
cornify1536253cornify
diff116228843__diff
doff116225783do__ff
eonian6311833eonian
eonism83213533eonism
gaff114828153g__aff
ganef96322463gan_ef
ganefs10489203ganefs
ganof95420363gan_of
ganofs104010293ganofs
gasify1336333gasify
genial74917613genial
genic85119393geni_c
genie66124923geni_e
genies75324943genies
genii64514173geni_i
genip84415203geni_p
genips9469943genips
genius74512923genius
gift86735793g__ift
gliffs13436323g_liffs
glorify1444583glorify
gobies95418063gobies
going75218493go_ing
goings84911523goings
golf85731183go__lf
golfs95616103go_lfs
gonad75216053gon_ad
gonads84511733gonads
gone55639043gon__e
goner66025163gon_er
goners74420173goners
gong66827193gon__g
gonged97115913gonged
gonging103713033gonging
gongs74921613gon_gs
gonidia975903gonidia
gonidic1166103gonidic
gonoph1235403gonoph
gonzo15310243gon_zo
goof85436873go__of
goofs94821003go_ofs
goofy124915623go_ofy
gooier73516213gooier
goonie73615563gooni_e
goonier83612843goonier
goonies83618333goonies
gopik1257533gopi_k
gorier73719373gorier
gorily10612503gorily
goring84119573goring
gowning12258833gowning
goyim1148603goyi_m
goyish13379013goyish
grief95319783g_rief
griffe13438093g_riffe
griffs13398993g_riffs
grift95924463g_rift
gruff124712143g_ruff
guff114624933g__uff
gunite7414403gunite
honied104818393honied
honing103421503honing
howff175110493ho_wff
iff96730393___iff
ignify1334513ignify
ionic74622663ioni_c
ionics84214483ionics
ionise63516943ionise
ionium8610923ionium
ionize154613873ionize
jiff175321413__jiff
knife1210010133_knife
miff125625063__miff
minify1439253minify
modify1537173modify
monie75631653moni_e
monied94319463monied
monies83233163monies
monish114217593monish
monism104016313monism
monist84324983monist
motif10519683moti_f
motifs1139673motifs
naff105128933__naff
nonlife1038553nonlife
notify1236943notify
off96331633_o__ff
onion54320973_onion
onium73115533_onium
ponied94920703ponied
ponies84833463ponies
pontiffs1643143pontiffs
pouff135215423po_uff
quiff201111563_quiff
riff104430103__riff
ronion63315643ronion
runoff1235413runoff
skiff153612803_skiff
sniffs12378843_sniffs
sniffy15337193_sniffy
snuff113514043_snuff
sonic75225293soni_c
sonics84315633sonics
spiff133616403_spiff
spliff1438603spliff
stiff114219243_stiff
tariff12711363tariff
tiff104727723__tiff
toff105929903to__ff
tonic74727653toni_c
tonics83617863tonics
tonier65520713tonier
toning74025793toning
tonish93415903tonish
unify113611113_unify
vinify1536923vinify
whiff17310063_whiff
yoni77524393yoni__
yonic105920843yoni_c
yonis85020823yoni_s
zoning162914333zoning

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.393454684.5
2DLD Change Limit1127161654.92022909.8
3Display Results1651650.0463587.0
 (SQL Overall)1786911655.35933344.1
 
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.