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

236 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
tongs6592846(None) 
bongs87828421bongs
dongs76525811dongs
gongs74921611gongs
hongs95126201hongs
longs65527061longs
pongs85526341pongs
songs67725551songs
tangs65028341tangs
thongs104611191thongs
tings65329201tings
togs57242431to_gs
tones56048661tones
tong56434351tong_
tonga65619691tonga
tongas74315521tongas
tons46553051ton_s
tonus56324301tonus
tungs65520621tungs
atones65225772atones
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_
hongi96715872hongi
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
mons68152262mon_s
noggs75811182noggs
nogs56534612no_gs
nonas55126652nonas
nones55639132nones
ones46146532_ones
onos46229002_onos
ons36148512_on_s
onus45826812_onus
pangs84628662pangs
pings85830882pings
ponds85323402ponds
pones74547042pones
pong76231142pong_
pons65850602pon_s
prongs94314482prongs
pungs85422222pungs
rings65029172rings
rungs611819402rungs
sings65532702sings
snogs66017492snogs
sones55444142sones
song55133672song_
sons46049552son_s
stangs75018162stangs
stings76220182stings
stones65130032stones
tags55545232t_ags
tang56138672tang_
tanga64923692tanga
tango66921172tango
tangos74216302tangos
tangy94519932tangy
tanks94624732tanks
tans46154822tan_s
teggs74710742teggs
tegs56031492t_egs
tends65425582tends
tenge65720442tenge
tens45647412ten_s
tents56434212tents
things104914302things
thong95014182thong_
throngs11508162throngs
thugs95611992thugs
tines54848422tines
ting56139902ting_
tinge64626622tinge
tinges74722332tinges
tins45251302tin_s
tints56030922tints
toads65621072toads
tods56141842to_ds
toeas55726422toeas
toes46956442to_es
toffs116016722toffs
tofts84919242tofts
tofus86415422tofus
tog410255042to_g_
toga57027412to_ga
togas67823002togas
toils54527492toils
toits55327472toits
tokes95234972tokes
tolas54532772tolas
toles55147132toles
tolls54728432tolls
tolus55024482tolus
tombs97818732tombs
tomes76037382tomes
toms68343492to_ms
ton310265102ton__
tonal53724302tonal
tondi65716142tondi
tondo69718682tondo
tondos75115922tondos
tone46953742ton_e
toned65435342toned
toner55336242toner
toners64128002toners
toney86027412toney
tonged86518902tonged
tonger74719682tonger
tongers84116012tongers
tongue7410092tongue
tongues879692tongues
tonic74727652tonic
tonics83617862tonics
tonish93415902tonish
tonne54921432tonne
tonnes65320852tonnes
tony75635152ton_y
tools55325242tools
toons55027532toons
toots55331872toots
topes76941762topes
tophs105220052tophs
topis76025832topis
topos75726392topos
tops66248122to_ps
toras55540372toras
torcs75123762torcs
tores55352672tores
toros54336192toros
torrs53923562torrs
tors46157382to_rs
torts56138122torts
torus54329762torus
toss45637972to_ss
totes55139682totes
tots46654122to_ts
tough97321982tough
toughs105414982toughs
tours55325892tours
touts54830392touts
towns86018882towns
tows78545552to_ws
toyos87519142toyos
toys78036342to_ys
trigs65423062trigs
trogs67022602trogs
tronas63816902tronas
trones65629282trones
trugs65516802trugs
tugs56231672t_ugs
tunas54224122tunas
tunes55332192tunes
tung55328162tung_
tuns45138662tun_s
twangs10358092twangs
twigs96911172twigs
tynes85920302tynes
vangs96319582vangs
wings95727242wings
wogs86531402wo_gs
wonks124818342wonks
wons74942042won_s
wonts87621542wonts
wrongs10338932wrongs
yangs95618692yangs
yonis85020822yonis
youngs1035382youngs
zings154620892zings
zones145528042zones
zonks184815172zonks

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 Limit538002361.45337026.8
3Display Results2362360.0633746.0
 (SQL Overall)1786912361.84297009.2
 
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.