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

(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
dungs7582197(None) 
bungs85323861bungs
dangs75623201dangs
dings76331401dings
dongs76525811dongs
dugs614832281du_gs
dunes65332171dunes
dung66328431dung_
dungy104713641dungy
dunks105621191dunks
duns55140431dun_s
dunts65828411dunts
lungs65223881lungs
pungs85422221pungs
rungs611819401rungs
tungs65520621tungs
aunts55227632aunts
bangs85627772bangs
bongs87828422bongs
bugs76035912bu_gs
bunas75126572bunas
bunds85523542bunds
bung75730632bung_
bunks115125082bunks
bunns74718292bunns
buns66243722bun_s
bunts75729802bunts
burgs84924092burgs
cunts76125122cunts
dags66642592d_ags
dang65131532dang_
dans56748142dan_s
daunts75014082daunts
denes65639722denes
dens55945072den_s
dents65031802dents
digs66036052d_igs
dines66449152dines
ding66940952ding_
dinge75627302dinge
dinges83825422dinges
dingo74720792dingo
dingus83611842dingus
dingy105721262dingy
dinks105927952dinks
dinos65428062dinos
dins56652042din_s
dints67431312dints
dogs66440152d_ogs
doings84913182doings
donas65926472donas
dong66031652dong_
donga76718422donga
dongas84914612dongas
dons56048702don_s
drags75521112drags
dregs76114862dregs
drugs75214652drugs
drunks11427512drunks
duads76515342duads
duals65620082duals
dubs78432192du_bs
duces86327472duces
ducks124823212ducks
ducts85319892ducts
dudes75424372dudes
duds65530142du_ds
duels65619232duels
dues56045502du_es
duets65323882duets
duffs125216622duffs
dufus94010812dufus
dug58138692du_g_
dugongs1053252dugongs
duits65021882duits
dukes105023472dukes
dulls64523742dulls
dumas85420432dumas
dumbs105915752dumbs
dumps105220102dumps
dun46545582dun__
dunam8313732dunam
dunams937832dunams
dunce86319262dunce
dunces95215752dunces
dunch115316262dunch
dune56137582dun_e
dunged95414692dunged
dunk96228572dun_k
dunt55746872dun_t
duos56728132du_os
dupes86425932dupes
dups75929512du_ps
duras65727722duras
dures65635922dures
durns64819862durns
duros65422692duros
durrs65519992durrs
dusks105317252dusks
dusts65923562dusts
dyings11478132dyings
dynes95917582dynes
engs56121392_engs
fangs96224072fangs
fugs85730692fu_gs
funds94119252funds
fungi95014132fungi
fungo94413132fungo
fungus10418182fungus
funks125318912funks
funs75235732fun_s
gangs76222572gangs
gongs74921612gongs
gunks104517722gunks
guns55533482gun_s
hangs95726722hangs
hongs95126202hongs
hugs86129752hu_gs
hung86126352hung_
hunks125321452hunks
huns76136932hun_s
hunts86826172hunts
jugs125525602ju_gs
junks164815972junks
kings105825562kings
lings67135772lings
longs65527062longs
lugs55233522lu_gs
lunas55025012lunas
lunes55337772lunes
lung55732492lung_
lunge65323802lunge
lunges76123422lunges
lungi65516052lungi
lungis77113022lungis
lunks94822452lunks
lunts55826902lunts
muggs94912322muggs
mugs76232042mu_gs
mungo84916052mungo
mungos94311372mungos
munis75022002munis
muns65535912mun_s
nuns45228232nun_s
pangs84628662pangs
pings85830882pings
pongs85526342pongs
pugs76332772pu_gs
punas74826752punas
pung75429632pung_
punks114822682punks
puns66641482pun_s
punts75828002punts
quags154613252quags
rings65029172rings
rugs56033682ru_gs
runes55530222runes
rung56429972rung_
runs46438072run_s
runts55927632runts
sings65532702sings
snugs64913022snugs
songs67725552songs
sung55832172sung_
sunns55017352sunns
suns45841902sun_s
tangs65028342tangs
tings65329192tings
tongs65928462tongs
tugs56231672tu_gs
tunas54224122tunas
tunes55332192tunes
tung55328162tung_
tuns45138662tun_s
uns35936752_un_s
vangs96319582vangs
vuggs10579132vuggs
vugs87022872vu_gs
wings95727242wings
yangs95618692yangs
youngs1035382youngs
zings154620892zings

Search took 5 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.186960704.3
2DLD Change Limit538001823.59314973.6
3Display Results1821820.0961895.8
 (SQL Overall)1786911823.87546113.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.