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

87 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
noggs7581118(None) 
hoggs107212461hoggs
nogg65115941nogg_
nogs56534611no_gs
boggy126116072boggy
bogs75742752bo_gs
bogus85616472bogus
bongs87828422bongs
cogs77340032co_gs
doges75630162doges
doggo84410702doggo
doggy115214872doggy
dogs66440152do_gs
dongs76525812dongs
eggs66516152_eggs
foggy136714542foggy
fogs87035002fo_gs
gloggs935032gloggs
gogos77516522gogos
gongs74921612gongs
hogg96617532hogg_
hogs87139662ho_gs
hongs95126202hongs
iggs66612672_iggs
jaggs148111492jaggs
jogs127129332jo_gs
loges66534202loges
loggy105714192loggy
logos67225332logos
logs57343112lo_gs
longs65527062longs
miggs96311372miggs
moggy125212162moggy
mogs75439332mo_gs
muggs94912322muggs
naggy106612822naggy
nags55436022n_ags
negs55727362n_egs
negus64513562negus
nighs95013612nighs
nobs66436902no_bs
nocks115121012nocks
nodes64633492nodes
nods55838222no_ds
nodus66315992nodus
noels56418702noels
noes45845392no_es
nog46847312no_g_
nogged95716332nogged
noggin8288882noggin
noggins9288452noggins
noils55024332noils
noirs55615462noirs
nolos54423352nolos
nomas74726412nomas
nomes74933122nomes
nomos75919742nomos
noms65636402no_ms
nonas55126652nonas
nones55639132nones
nooks95420392nooks
noons54125282noons
noris54928272noris
norms76019312norms
nos38859322no__s
noses55435642noses
notes55034582notes
nouns56717312nouns
nous46136982no_us
novas85215362novas
nows75738232no_ws
nowts86915862nowts
pongs85526342pongs
raggs75216472raggs
snogs66017492sno_gs
soggy105413902soggy
songs67725552songs
teggs74710742teggs
togas67823002togas
togs57242432to_gs
tongs65928462tongs
vuggs10579132vuggs
wogs86531402wo_gs
yeggs10608162yeggs
yogas96615602yogas
yoghs125410592yoghs
yogis95617742yogis

Search took 4 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.686260482.5
2DLD Change Limit53800873.00017933.3
3Display Results87870.0461891.3
 (SQL Overall)178691873.73247880.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.