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

127 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
corymbs163345(None) 
corymb1535221corymb_
combs116122962co__mbs
coombs124210192co_ombs
corms95626222cor_m_s
corymbed1842612corymbed
corymbose1842302corymbose
corymbous1842732corymbous
coryzas2134802coryzas
crumbs12409232c_rumbs
bombs115818823bo__mbs
caramba1336893caramba
carbs96031463car__bs
carobs104818103car_obs
caroms105619573carom_s
chimbs153910303c_himbs
choriambs1842453choriambs
chromas142512693chromas
chromes142914933chromes
chromos142610273chromos
chymes165912153c_hymes
climbs12498723c_limbs
cobbs115013993co__bbs
cobs87043143co___bs
cobwebs1631933cobwebs
columns1136473columns
comas95833003co__mas
comb106632113co__mb_
combe116223543co__mbe
combes125321733co__mbes
combo114519433co__mbo
combos125316613co__mbos
comes97246993co__mes
commas124814573co_mmas
comps115526053co__mps
comsymps1941013comsymps
confabs1435393confabs
coomb115615703co_omb_
coombe124110093co_ombe
coombes133810663co_ombes
corals85325143cor_als
corbans11313173corbans
corbels113813593corbels
corbies113520123corbies
corby125018533cor__by
corders104520883corders
cordoba1255743cordoba
cordobas1345803cordobas
cordons104415763cordons
cords86030623cor__ds
coremia11310363coremia
corers85231073cor_ers
cores76361853cor__es
corgis9314413cor_gis
corkers134118853corkers
corks116028273cor__ks
corm85735383cor_m__
cormel103815603cor_mel
cormels113813373cormels
cormous11312353cormous
corncobs1444723corncobs
corneas94717003corneas
cornels94716663cornels
corners94723313corners
cornets94820573cornets
corns76034763cor__ns
cornus84816563cor_nus
coronas93916913coronas
corps95927043cor__ps
corpses113913813corpses
corpus106015293cor_pus
corrals93713853corrals
corries94026803corries
cors66656443cor___s
corsacs1139013corsacs
corses84433463cor_ses
corsets94819803corsets
cortins92421333cortins
corvees124613793corvees
corves115122523cor_ves
corvets124715023corvets
corvids1337683corvids
cory96941513cory___
coryza2074583cory_za
coryzal2154823coryzal
cosmos10311753co_smos
cotypes1437943cotypes
coulombs1443093coulombs
coxcombs2342353coxcombs
coypus13389303co_ypus
coys97537243co_y__s
crabs95421393c_r_abs
crambe1239073c_rambe
crambes1339963c_rambes
crambo1238043c_rambo
crambos1336783c_rambos
cramps125615563c_ramps
crams96229153c_ram_s
cremes104517993c_remes
cribs94516753c_r_ibs
crimes105521583c_rimes
crimps124613453c_rimps
crumb114313593c_rumb_
crumby15408113c_rumby
crumps124514343c_rumps
crypts13397743c_rypts
curbs94821653cur__bs
cymas126417883c__ymas
cymes1210118923c__ymes
dorms85723843dor_m_s
forams115115913foram_s
forbs105720803for__bs
formes114623713for_mes
forms105327053for_m_s
formyls15235703formyls
forums114611843forum_s
gorms85619593gor_m_s
jorams154810533joram_s
jorums15408093jorum_s
kormas124511233kor_mas
norms76019313nor_m_s
orbs66626253_or__bs
oryxes1674523_oryxes
sorbs75022103sor__bs
tombs97818733to__mbs
wombs125813343wo__mbs
worms105320763wor_m_s

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 Limit1340271276.81319672.2
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.26524596.1
 
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.