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

182 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
fungous1136743(None) 
fungoes11388811fungoes
fungus10418181fung_us
congous103615082congous
fucous11399862fu_cous
fugus95914012fu_g_us
fulvous1334542fulvous
fundus10429172fun_dus
fungals11276782fungals
fungo94413132fungo__
fungoid1245252fungoid
fungoids1343992fungoids
funhouse1444522funhouse
furious103110632furious
fuscous1256672fuscous
mungoes103510462mungoes
mungos94311372mungo_s
rugous739652ru_gous
aduncous1143163aduncous
aeneous739893aeneous
anurous7311553anurous
aurous64119263au_rous
azygous2043123azygous
bingoes104013983bingoes
bingos95514793bingo_s
bongoes104314113bongoes
bongos95316653bongo_s
bugout9311863bu_gout
bugouts1036193bu_gouts
bulbous1138293bulbous
bullous9311663bullous
buncos104011593bunco_s
bungees104513103bungees
bungles104116763bungles
bungs85323863bung__s
bunions92210473bunions
bunkos124210323bunko_s
burgoos1037123burgoos
burgout1049773burgout
burgouts1145123burgouts
burnous938823burnous
congius103210073congius
congoes103617303congoes
congos94219883congo_s
congou94313243congou_
cuprous1149743cuprous
curious93813563curious
dingoes94114833dingoes
dingus83611843ding_us
dubious1036893dubious
dugout8310363du_gout
dugouts935043du_gouts
dungeons10124623dungeons
dungs75821973dung__s
duteous838453duteous
faggots1234863faggots
fagots1039963f_agots
famous11412393f_amous
fandoms13229473fandoms
fangas105017203fang_as
fangs96224083fang__s
fanions103713073fanions
fanons96115213fan_ons
fanos85926503fan_o_s
fantods11177623fantods
fantoms12189153fantoms
fatuous1037783fatuous
ferrous1049803ferrous
fibrous1237593fibrous
fingers113418433fingers
finos86226953fin_o_s
flagons1137973flagons
folious103710733folious
fondus105210943fon_dus
forgoes11311353forgoes
fourgons1234833fourgons
fucus105515893fu__cus
fudges114314503fudg_es
fugios1037583fu_gios
fugles104715783fu_gles
fugs85730693fu_g__s
fugu85419863fu_g_u_
fugue94313373fu_g_ue
fugues104511683fu_gues
fulgurous1342733fulgurous
fumulus1234443fumulus
functors1335743functors
funders113813933funders
funds94119253fun__ds
fungal10388733fung_al
fungi95014133fung__i
fungic12387813fung_ic
funguses1254713funguses
funhouses1544593funhouses
funkers143712063funkers
funkias1435383funkias
funks125318913fun__ks
funnels10348173funnels
funnies104113603funnies
funs75235733fun___s
furors9310953fu_rors
furrows13327793furrows
fusions1039153fusions
futons93911513fu_tons
fynbos1433283fynbo_s
gummous1236263gummous
gundogs1034603gundogs
hangout11411393hangout
hangouts1236183hangouts
hugeous1137133hugeous
humongous1543093humongous
humungous1552083humungous
hungers114013303hungers
igneous835773igneous
ingots7912063_ingots
jingoes153811443jingoes
juncoes16338073juncoes
juncos15449233junco_s
jungles154112543jungles
juniors1475783juniors
juntos134110843junto_s
lingoes84014693lingoes
lungans8399053lungans
lungees84412143lungees
lungers83817093lungers
lunges76123423lung_es
lungful1144013lungful
lungfuls1242773lungfuls
lungis77113023lung_is
lungs65223883lung__s
lungyis11294103lungyis
lupous849433lu_pous
luteous739273luteous
mangoes104316133mangoes
mangos94319343mango_s
mongoes103415713mongoes
mongols103310823mongols
mongos94318623mongo_s
mucous104411653mu_cous
mungo84916053mungo__
mungoose1153223mungoose
nous46136983__n_ous
outgoes8312643outgoes
pengos94612413pengo_s
pingoes105116523pingoes
pingos95317673pingo_s
pulpous1177013pulpous
pungles104013713pungles
pungs85422223pung__s
puntos85915793punto_s
quangos1734653quango_s
rubious938283rubious
rufous948273ru_fous
ruinous739763ruinous
rungs611819403rung__s
runout6414873run_out
runouts737353run_outs
sanious7514103sanious
sinuous739063sinuous
sunbows1236023sunbows
sundogs947103sundogs
sunglows1244083sunglows
tangos74216323tango_s
tenuous738483tenuous
tungs65520633tung__s
turgors836833turgors
unaus53216573_un_aus
uncos74117033_unco_s
uncus74014983_un_cus
undoes73917403_undoes
unglue748003_unglue
unglues836993_unglues
ungot61718063_ungo_t
ungues7412123_ungues
unguis738453_unguis
unhouse1038923_unhouse
unions64216753_unions
uveous936603_uveous
venous93713193ven_ous
vinous93914173vin_ous
vulgus1035783vulg_us
zincous1837053zincous

Search took 9 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 Limit1340271827.53017799.1
3Display Results1821820.0802275.0
 (SQL Overall)1786911828.01622291.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.