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

196 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
concave143937(None) 
concaved1636221concaved
concaves1538911concaves
conclave1556401conclave
biconcave1862092biconcave
concavely1943672concavely
concede12310102concede
conceive1539232conceive
conchae143911642conchae
conchie143312682conchie
concise11314472concise
conclaves1646542conclaves
connate9315752connate
connive1238992connive
corncake1645262corncake
bondage1138253bondage
boscage1276533boscage
canape10913513can_ape
cancan10314103canca_n
cancans11311873cancans
carcase11312743carcase
cascade12118603cascade
cave95941263___cave
cenacle1139123cenacle
centare93113703centare
centavo1245103centavo
chicane1489553chicane
cicale10314503c_icale
clave105420153c__lave
cleave114212513c_leave
cloacae1145233cloaca_e
coactive1598623coactive
coca88030643co_ca__
cocain101315013co_cain
cocaine111315173co_caine
cocas95926573co_ca_s
coccal9310223cocca_l
cockade1638133cockade
cockle143913573co_ckle
codrive1337653codrive
codrove1336423codrove
coercive1545873coercive
cognate10312203cognate
coinage10310553coinage
coincide1346493coincide
coinmate1239063coinmate
collage102813763collage
collate92919683collate
colocate12313443colocate
comade114415323co_made
comae97128423co_ma_e
comake144413423co_make
comate104124843co_mate
commove1635963commove
compare135814993compare
comrade12139213comrade
conative131214623conative
concaving1737353concaving
concavity1944623concavity
conceal113313013conceal
concealed1458133concealed
concealer1368223concealer
conceals123111013conceals
conceded1438293conceded
conceder1338743conceder
concedes13311063concedes
conceit113218073conceit
conceived1746713conceived
conceiver1657413conceiver
conceives1639233conceives
concent114422513concent
concept133314443concept
concern113011963concern
concert113325223concert
conch124620073conc__h
concha134213283conc_ha
conchal144211583conchal
conchas144013313conchas
conches144019813conches
conchies153214853conchies
concho134414263conc_ho
conchos144313963conchos
conchs134714903conc_hs
conchy163710223conc_hy
conciser12310243conciser
conclude1344673conclude
concoct10312903concoct
concord12510343concord
concrete12411083concrete
concur10411103conc_ur
concurs11311473concurs
concuss1138063concuss
condole102914953condole
condone102616293condone
conduce12139233conduce
conducive1745283conducive
condyle13247053condyle
cone67256963con___e
conepate12712533conepate
confab1347063confa_b
confabs1435393confabs
confide13310203confide
confine12315583confine
conflate13311173conflate
confuse1238853confuse
confute1239263confute
conga85419873conga__
congaed11399743congaed
congas94417033conga_s
conge85227593con__ge
congee96024473con_gee
conical11316203conica_l
coniine9316803coniine
conine84528553con_ine
conjure16109073conjure
connived1436433connived
conniver1337493conniver
connives1339723connives
connote9311613connote
conserve1339933conserve
console92715983console
consume11510133consume
contact1144020683contact
contain9315833contain
conte76633203con__te
contrive13311353contrive
contuse9311413contuse
convene123314323convene
convex18367743con__vex
convey144610223con__vey
convoke16207173convoke
convolve1644653convolve
cooncan1147233coonca_n
cooncans1246273cooncans
coracle112011723coracle
cordage11310063cordage
cordate10315223cordate
corkage1438373corkage
corncakes1745013corncakes
corncrake1743263corncrake
corrade101111043corrade
corsage1039803corsage
costae85319683costa_e
costate94019273costate
costive12312843costive
cottae84615703cotta_e
cottage104210573cottage
courage10310993courage
couvade1335063couvade
cove95837073co___ve
cowage12310673co_wage
cowbane1437673cowbane
cowhage1636303cowhage
coxae146115183co_xa_e
crave105626313c__rave
cuneate9311723cuneate
cupcake1743953cupcake
donate73619503don_ate
encage93713503_encage
encase83714363_encase
enclave1257533_enclave
forgave1435853forgave
hoecake1645203hoecake
hotcake1644543hotcake
incage93513623_incage
incase83615283_incase
knave12389463_kn_ave
locale83915653lo_cale
locate83919843lo_cate
montage101211713montage
montane91313623montane
nave75732313__n_ave
nonage7313683non_age
noncash1245163noncash
nonce75719823nonc__e
noncore9411953noncore
nongame1038183nongame
nonwage1137163nonwage
octave11157343_octave
once65423083_onc__e
pancake1536673pancake
ponce95222513ponc__e
sconce104711723sconc__e
soave84219053so__ave
socage91012123so_cage
soccage1236283soccage
sonicate10310933sonicate
toccate1138773toccate
tonnage8168053tonnage
uncage93014873_uncage
uncake122813523_uncake
uncase83817433_uncase
zincate1838533zincate
zonae145116443zon_a_e
zonate154114923zon_ate
zouave1833573zo_uave

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.420425454.8
2DLD Change Limit1340271967.19018640.8
3Display Results1961960.0633111.1
 (SQL Overall)1786911967.67323288.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.