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 “fugus” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
fugus9591401(None) 
fucus105515891fucus
fugs85730691fug_s
fugu85419861fugu_
fugue94313371fugue
fugues104511681fugues
fungus10418181fungus
argus66716542argus
augur64311212augur
augurs7399962augurs
august739202august
bogus85616472bogus
bubus95115452bubus
bugs76035912bug_s
dufus94010812dufus
dugs614832282dug_s
fags86939122fag_s
favus114311732favus
fetus85816542fetus
feus75830752f_eus
ficus105015492ficus
figs85332652fig_s
flus75626542f_lus
focus105815882focus
fogs87035002fog_s
frugs96114282frug_s
fubs96328792fu_bs
fucks144419252fucks
fucous11399862fucous
fudges114314502fudges
fuds86528572fu_ds
fuels87117352fuels
fug76234512fug__
fugal95613032fugal
fuggy135411672fuggy
fugio9310922fugio
fugios1037582fugios
fugle94915542fugle
fugles104715782fugles
fugued11478712fugued
fuguist1136072fuguist
fujis15379242fujis
fulls84623522fulls
fumes105224702fumes
funds94119252funds
fundus10429172fundus
fungous11367432fungous
funks125318912funks
funs75235732fu_ns
furls85322052furls
furs76735042fu_rs
fuses85628422fuses
fuss76027932fu_ss
fuzes175120222fuzes
gurus64318192gurus
hugs86129752hug_s
humus106215072humus
jugs125525602jug_s
jugum15167472jugum
jugums16104672jugums
jujus11347462jujus
jukus16398672jukus
kagus105812032kagus
kudus104910812kudus
kurus98015632kurus
luaus54514902luaus
luges65928752luges
lugs55233522lug_s
lulus54315162lulus
lupus74512522lupus
lusus54813872lusus
magus85318752magus
mucus94015742mucus
muggs94912322muggs
mugs76232042mug_s
mumus95517282mumus
negus64513562negus
pugs76332772pug_s
pupus94614042pupus
rubus76415062rubus
rugous739652rugous
rugs56033682rug_s
sughs95313322sughs
sulus54821882sulus
tugs56231672tug_s
tutus55214812tutus
ughs85410972_ughs
ulus45622562_ulus
urus46426142_urus
vagus96713812vagus
vuggs10579132vuggs
vughs12678742vughs
vugs87022872vug_s
vulgus1035782vulgus
yugas95012062yugas

Search took 2 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 Filter178691538000.326548131.9
2DLD Change Limit53800951.36039558.8
3Display Results95950.0303166.7
 (SQL Overall)178691951.716104132.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.