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

227 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
pongs8552634(None) 
bongs87828421bongs
dongs76525811dongs
gongs74921611gongs
hongs95126201hongs
longs65527061longs
pangs84628661pangs
pings85830881pings
ponds85323401ponds
pones74547041pones
pong76231141pong_
pons65850601pon_s
prongs94314481prongs
pungs85422221pungs
songs67725551songs
tongs65928461tongs
bangs85627772bangs
bogs75742752bo_gs
boings96416872boings
bonds86126842bonds
bones76446532bones
bong75633412bong_
bongo85720942bongo
bongos95316652bongos
bonks116326462bonks
bonus75324322bonus
bungs85323862bungs
cogs77340032co_gs
cones76457422cones
conga85419872conga
congas94417032congas
conge85227592conge
conges94928172conges
congo85623132congo
congos94219882congos
conks115525702conks
conns75024232conns
cons66057692con_s
conus76726532conus
dangs75623202dangs
dings76331402dings
dogs66440152do_gs
doings84913182doings
donas65926472donas
dong66031652dong_
donga76718422donga
dongas84914612dongas
dons56048702don_s
dungs75821972dungs
engs56121392_engs
eons46638712eon_s
fangs96224072fangs
flongs105010492flongs
fogs87035002fo_gs
fonds95824822fonds
fons76943892fon_s
fonts86124752fonts
gangs76222572gangs
goings84911522goings
gong66827192gong_
hangs95726722hangs
hoggs107212462hoggs
hogs87139662ho_gs
hones88144492hones
hong85833952hong_
hongi96715852hongi
honks125124522honks
hons77350782hon_s
ions46737852ion_s
jogs127129332jo_gs
jones125028182jones
kings105825562kings
klongs11436602klongs
konks84917112konks
lings67135772lings
logs57343112lo_gs
long56933342long_
longe66626462longe
longes75925572longes
lungs65223882lungs
mogs75439332mo_gs
monas74732152monas
mongo810122412mongo
mongos94318622mongos
mongst93512602mongst
monks116123392monks
monos75930862monos
mons68152252mon_s
noggs75811182noggs
nogs56534612no_gs
nonas55126652nonas
nones55639132nones
ones46146532_ones
onos46229002_onos
ons36148512_on_s
onus45826812_onus
panes76148692panes
pang75336282pang_
panga85323532panga
pangas99921102pangas
pans65855722pan_s
pants76536922pants
peags86122842peags
pegs75531762p_egs
pends85527192pends
penes75839222penes
pengo84317592pengo
pengos94612412pengos
penis75129322penis
pens65649642pen_s
peones83821042peones
peons75327182peon_s
phones114121212phones
phonos114114792phonos
phons105221142phon_s
pigs76634222p_igs
pinas75434452pinas
pines76048862pines
ping75943592ping_
pingo87122712pingo
pingos95317672pingos
pinks115729382pinks
pins65558452pin_s
pints75936222pints
pions75826392pion_s
plonks124210422plonks
plugs85213492plugs
pocks135022962pocks
podgy125610772podgy
pods76540152po_ds
poems95715552poems
poets76024442poets
pogy105623552po_gy
poinds93511142poinds
points85618532points
pois66539042po_is
pokes116133012pokes
poles75351002poles
polis74731162polis
polls74627722polls
polos76129912polos
pols66044562po_ls
polys105718762polys
pomes94833932pomes
pomos95321582pomos
pomps115316192pomps
poms87037742po_ms
ponce95222512ponce
ponces104720842ponces
pond75530492pon_d
pone65747532pon_e
ponged105619352ponged
pongee94920192pongee
pongees104212542pongees
pongid104111582pongid
pongids11347412pongids
ponies84833462ponies
pontes83627852pontes
pony96434052pon_y
poods85124752poods
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poons75430972poons
poops94422412poops
poos65949112po_os
popes95933812popes
pops86340952po_ps
pores75849032pores
porgy116916122porgy
porks115124142porks
pornos85015252pornos
porns75527342porns
ports75934592ports
poses74642762poses
posts75228782posts
pots66452362po_ts
poufs105616062poufs
pounds93714382pounds
pours74623182pours
pouts75530322pouts
pows95537662po_ws
poxes145325722poxes
prangs94816232prangs
prigs85219702prigs
progs86624152progs
prong85218112prong_
pugs76332772p_ugs
punas74826752punas
pung75429632pung_
punks114822682punks
puns66641482pun_s
punts75828002punts
rings65029172rings
rungs611819402rungs
sings65532702sings
snogs66017492snogs
sones55444142sones
song55133672song_
sons46049552son_s
sponge939662sponge
sponges10311042sponges
spongy1236742spongy
tangs65028342tangs
thongs104611182thongs
tings65329192tings
togs57242432to_gs
tones56048662tones
tong56434352tong_
tonga65619682tonga
tongas74315512tongas
tons46553052ton_s
tonus56324302tonus
tungs65520622tungs
vangs96319582vangs
wings95727242wings
wogs86531402wo_gs
wonks124818342wonks
wons74942042won_s
wonts87621542wonts
wrongs10338932wrongs
yangs95618692yangs
yonis85020822yonis
youngs1035382youngs
zings154620892zings
zones145528042zones
zonks184815172zonks

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.0931921408.6
2DLD Change Limit538002273.20316796.8
3Display Results2272270.1261801.6
 (SQL Overall)1786912273.42252218.3
 
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.