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

102 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
goniffs1447390(None) 
goniff13408891goniff_
gonifs104310131goni_fs
gliffs13436322g_liffs
gonefs10439872gon_efs
gonif94320922goni_f_
gonofs10459862gon_ofs
griffs13398992g_riffs
pontiffs1643142pontiffs
sniffs12378842_sniffs
agonies83016623agoni_es
agonises92613163agonises
agonists9289833agonists
agonizes182610583agonizes
biffs134814413__biffs
boffs134915503bo__ffs
bonitas939453bonitas
bonitos939733bonitos
cliffs14477593_cliffs
coffs134916303co__ffs
coiffe1447043co_iffe
coiffes1546803co_iffes
coifs105718703co_i_fs
confits122811423confits
conics103920593coni_cs
conies84338593coni_es
conifer123212643conifer
conifers133611703conifers
conines93827793conines
conins84327233coni_ns
coniums11311863coniums
diffs126315483__diffs
doffs125614333do__ffs
eonisms92811043eonisms
gaffs124914653g__affs
ganefs10489203gan_efs
ganofs104010293gan_ofs
genies75324943geni_es
genips9469943geni_ps
genius74512923geni_us
gifts96214963g__ifts
gliff124915663g_liff_
gobies95418063gobi_es
goings84911523go_ings
golfs95616103go__lfs
gonads84511733gon_ads
gonef95221293gon_ef_
goners74420173gon_ers
gongs74921613gon__gs
gonia64117533goni__a
gonidia975903gonidia
gonidic1166103gonidic
gonion73612833goni_on
gonium949803goni_um
gonof95218653gon_of_
gonophs1344453gonophs
goofs94821003go__ofs
goonies83618333gooni_es
griefs10418723g_riefs
griff124416463g_riff_
griffe13438093g_riffe
griffes14367923g_riffes
grifts104511683g_rifts
gruffs13337453g_ruffs
guffs124414823g__uffs
gunites8313123gunites
howffs18535043ho_wffs
ionics84214483ioni_cs
ionises72916433ionises
ioniums938303ioniums
ionizes162813343ionizes
jiffs185710313__jiffs
knifes136210213_knifes
miffs134512883__miffs
monies83233163moni_es
monisms113512803monisms
monists93614783monists
motifs1139673moti_fs
naffs116213963__naffs
offs107117013_o__ffs
onions64016433_onions
ponies84833463poni_es
pontiff1547903pontiff_
pouffs14418123po_uffs
quiffs21135433_quiffs
riffs115114613__riffs
ronions73313343ronions
runoffs1343013runoffs
skiffs16327013_skiffs
sniff113915863_sniff_
sniffy15337193_sniffy
snuffs12358533_snuffs
sonics84315633soni_cs
spiffs14328473_spiffs
spliffs1533563spliffs
stiffs12389963_stiffs
tariffs1334593tariffs
tiffs114414883__tiffs
toffs116016723to__ffs
tonics83617863toni_cs
whiffs1835083_whiffs
yonis85020823yoni__s

Search took 7 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.390458182.1
2DLD Change Limit1340271025.87622809.2
3Display Results1021020.0303400.0
 (SQL Overall)1786911026.29628381.7
 
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.