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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

164 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
kampong1629493(None) 
campong14318121campong
kampongs17293031kampongs
among85813302_am_ong
amping114317572_amping
camping143118972camping
campongs15356122campongs
damping133414002damping
kalong1177702ka_long
lamping123116002lamping
ramping123316872ramping
tamping122815812tamping
tampon102911232tampon_
tampons112711562tampons
vamping152810232vamping
along65419493_a_long
ammono1047373_ammono
aping87327233_a_ping
bamming144611813bamming
barong96015823ba_rong
bumping143812493bumping
cameoing1379063cameoing
camion103917193camion_
camions113916133camions
campings154010203campings
campion133011413campion_
campions143511293campions
campo115219763campo__
campos125217953campo_s
campout13412853campout
capon95221873ca_pon_
capons104119503ca_pons
capping143819673capping
carping123521083carping
champing183610933champing
clamping154011153clamping
comping143518593comping
compone136517193compone
compony1613011913compony
cramping153411853cramping
crampon1336943crampon_
crampons1436643crampons
damming133812743damming
damning114211633damning
dampen114310593dampen_
dampens12348563dampens
dampings14377523dampings
damson938063damson_
damsons1038013damsons
dapping133714793dapping
daylong1233973daylong
dumping133712913dumping
faming124922973fam_ing
gaming104622043gam_ing
gamming133112623gamming
gammon1138903gammon_
gammons1237973gammons
gaping105618923ga_ping
gapping134214783gapping
gasping113714363gasping
gawping14418463gawping
gimping133710763gimping
hambone1439313hambone
hamming153014093hamming
happing153817233happing
harping134118383harping
hasping134414903hasping
humping153213073humping
imping114315353_imping
impone103011863_impone
jambing19328533jambing
jamming19329793jamming
japing165013573ja_ping
jauping17307193jauping
jumping19319803jumping
kalongs1255443ka_longs
kamsin1238323kamsin_
kamsins1346963kamsins
kaon87521023ka__on_
kaons95014853ka__ons
kapok10448783ka_po_k
kapoks11347263ka_poks
karting123716063karting
kation104315683kation_
kations114013663kations
kayoing1535403kayoing
keeping144012543keeping
kelping14319193kelping
kepping16268593kepping
kimono12105413kim_ono
kipping163311873kipping
klong105310403k__long
knapping17314973knapping
lambing123412413lambing
laming94528363lam_ing
lamming123014583lamming
lampion11278303lampion_
lampions12277973lampions
lampoon11267193lampoon
lampoons12266873lampoons
lapping124117023lapping
limping124614113limping
lumping123314643lumping
mahjong2042273mahjong
mamboing1535973mamboing
mammon939643mammon_
mammons1048513mammons
mapping143413993mapping
mumping143411633mumping
naming93917893nam_ing
napping123514183napping
palping124112873palping
pimping143812123pimping
pompon1238943pompon_
pompons1338553pompons
pong76231143___pong
pumping144213553pumping
ramming123115063ramming
ramona8412413ram_ona
rampant11312173rampant
rampion11298583rampion_
rampions12248023rampions
rampole1139693rampole
ramson8310463ramson_
ramsons939563ramsons
raping94829853ra_ping
rapping123619103rapping
rasping104316253rasping
romping123113033romping
sampan102511893sampan_
sampans112411003sampans
sampling13510643sampling
sapping123519313sapping
sarong73914873sa_rong
scamping153510193scamping
skimping17306243skimping
stamping133310963stamping
swamping16307923swamping
taming94023433tam_ing
tampan102512323tampan_
tampans113310983tampans
tampion11298663tampion_
tampions12358123tampions
tamponed1336023tamponed
tamponing1445993tamponing
taping94222393ta_ping
tapping123317133tapping
tarpon82812803tarpon_
tarpons92612213tarpons
temping122710693temping
tramping132711273tramping
tumping123114243tumping
umping114815333_umping
wapping153514603wapping
warping133715183warping
wimping153911013wimping
yapon104613583ya_pon_
yapons114411773ya_pons
yapping153412613yapping
yauping13357243yauping
yaupon11345493yaupon_
yaupons12345683yaupons
yawping16357333yawping
zapping213211473zapping

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271646.53320515.4
3Display Results1641640.0602733.3
 (SQL Overall)1786911646.99925530.9
 
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.