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

138 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
campongs1535612(None) 
campings154010201campings
campong14318121campong_
kampongs17293031kampongs
camions113916132camion_s
camping143118972camping_
campions143511292campion_s
campos125217952campo__s
campouts1436822campouts
capons104119502ca_pon_s
cappings15369492cappings
carpings133812382carpings
crampons1436642crampon_s
dampings14377522dampings
kampong16294932kampong_
tampons112711552tampon_s
ambones11312683_ambones
among85813303_am_ong_
amongst1045363_am_ongst
amping114317573_amping_
barongs105310833ba_rongs
cajones163311333ca_jones
calkings15289223calkings
callings113613833callings
calzones1948763calzones
cameoing1379063cameoing_
cameos105818003cameo__s
camion103917193camion__
camos95927613cam_o__s
campagna1543413campagna
campagne1544413campagne
campaign1544213campaign
campaigns1643473campaigns
campers134220293camp_ers
camphenes1846463camphenes
camphines1847563camphines
camphols1746243camphols
camphors1737053camphors
campiness1537543campiness
campion133011413campion__
campo115219763campo___
camporee1449343camporee
camporees1546103camporees
campout13412853campo_ut
camps116330263camp___s
campus125213923camp__us
campuses1437773campuses
cannings113710333cannings
cannons94412883cannon_s
canons85522063ca_non_s
cantons95221203canton_s
canyons124511593canyon_s
canzonas1935383canzonas
canzones1939153canzones
capon95221873ca_pon__
capos94826073ca_po__s
capotes11314643ca_potes
capping143819673capping_
carbons115418943carbon_s
cardings123812633cardings
cardons104519933cardon_s
carlings114015853carlings
carping123521083carping_
carpools1237883carpools
carports1238943carports
cartons94122473carton_s
carvings143810203carvings
casings104013513ca_sings
castings113614053castings
cations94524143cation_s
catjangs1843223catjangs
catlings113712043catlings
cavings134712543ca_vings
champing183610933champing_
champions18875783champion_s
clamping154011153clamping_
coamings13349293coam_ings
combings15348323combings
comings124013533com_ings
commons13311043common_s
compends15378253compends
comping143518593comping_
compone136517193compon_e
compony1613011913compon_y
comports143411983comports
compos124818803compo__s
composes145017113composes
composts144210913composts
compotes144716513compotes
compounds1654503compounds
copings124111843c_opings
coupons112710563coupon_s
cramping153411853cramping_
crampon1336943crampon__
crampoons1544063crampoons
crepons1139313crepon_s
cuppings15336053cuppings
cymlings1634213cymlings
dampens12348563dampen_s
damping133414003damping_
damsons1038013damson_s
dumpings14295763dumpings
gamings114610913gam_ings
gammons1237973gammon_s
hambones1539673hambones
harpings14379773harpings
impings12348553_impings
impones112712253_impones
kalongs1255443ka_longs
lamping123116003lamping_
lampions12277973lampion_s
lampoons12266863lampoons
mahjongs2141813mahjongs
mammons1048513mammon_s
mappings15296413mappings
pompons1338553pompon_s
pongs85526343___pongs
ramonas9311093ram_onas
ramping123316873ramping_
rampions12248023rampion_s
rampoles1238893rampoles
ramsons939563ramson_s
raspings11337853raspings
sampans112411003sampan_s
samplings1435553samplings
sarongs84511803sa_rongs
scamping153510193scamping_
tampans113310983tampan_s
tamping122815813tamping_
tampions12358113tampion_s
tampon102911233tampon__
tamponed1336023tamponed
tappings13267713tappings
tarpons92612203tarpon_s
vamping152810233vamping_
yapons114411773ya_pon_s
yaupons12345683yaupon_s
yawpings17253583yawpings

Search took 10 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621388.98616265.5
3Display Results1381380.0463000.0
 (SQL Overall)1786911389.18819448.3
 
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.