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

252 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
connives133972(None) 
connive1238991connive_
connived1436431connived
conniver1337491conniver
connivers1436931connivers
codrives1437662codrives
cognises11610042cognises
cognizes2058032cognizes
concaves1538902concaves
conceives1639232conceives
confides14310572confides
confines13315652confines
conies84338592co_ni_es
coniines10415362coniines
conines93827792co_nines
connivent1447722connivent
connivery1744212connivery
connotes10311452connotes
contrives14311702contrives
cornices12713292cornices
nonlives1138362nonlives
sonnies7315222sonni_es
aconites10314353aco_nites
bennies93917313benni_es
bonfires1367383bonfires
bonnes85621453bonn__es
bonnie85314853bonni_e_
bonnier94711313bonni_er
bonniest10310773bonni_est
bonniness1136733bonniness
boonies93422483booni_es
bornites10310983bornites
bunnies94415003bunni_es
candies104125613candi_es
canines93724033c_anines
cannie83819363canni_e_
cannier94014163canni_er
canniest10313363canni_est
canniness1138643canniness
cannings113710333cannings
canonises11410803canonises
canonizes2049593canonizes
captives1538623captives
carnies94123963carni_es
centiles103615813centiles
centimes124012613centimes
chives144317593c__hives
coannexes1843643coannexes
cocaines121314443cocaines
codeines113114523codeines
coderives1547483coderives
codices12512583co_dices
codrive1337653codrive_
codriven1444393codriven
codriver1435913codriver
codrivers1544863codrivers
coenures1048683coenures
coesites101313093coesites
cognates11311583cognates
cognise1059683cognise_
cognised1256313cognised
cognize1957683cognize_
cognized2136293cognized
cognizer2055863cognizer
cognizers2164433cognizers
coinages11310803coinages
coincides1446433coincides
colies84837053co_li_es
collides113214463collides
collies94326583colli_es
colonies103620013coloni_es
colonises112814013colonises
colonizes202613183colonizes
combines142814623combines
commies133718453commi_es
commixes2177353commixes
commoves1736963commoves
compiles14311983compiles
conative131214623conative_
concave1439373concave_
concaved1636223concaved
concedes13311053concedes
conceive1539233conceive_
conceived1746713conceived
conceiver1657413conceiver
conceivers1746313conceivers
conches144019813co_nches
conchies153214853conchies
concise11314473concise_
conciser12310243conciser
concisest1348253concisest
conclaves1646543conclaves
condoes104319203co_ndoes
condoles113015803condoles
condones112817393condones
condores113315643condores
conduces13129783conduces
condyles14277463condyles
conenoses1188903conenoses
cones76457423co_n__es
confide13310203confide_
confided1537453confided
confider1438123confider
confiders1537483confiders
confine12315583confine_
confined14310403confined
confiner13311193confiner
confiners1439953confiners
confirms1536303confirms
confits122811423confi_ts
confuses13310363confuses
confutes1339843confutes
congees103517923co_ngees
conges94928173co_n_ges
congius103210073congi_us
congoes103617303co_ngoes
conics103920593co_ni_cs
conifer123212643co_nifer
conifers133611703co_nifers
coniine9316803coniine_
conine84528553co_nine_
conins84327233co_ni_ns
conioses10313313conioses
coniums11311863co_niums
conjures17119913conjures
connate9315753connate_
connectives1847503connectives
connects123010563connects
conned95119703conn__ed
conner84423963conn__er
conners94023113conn_ers
conning103718753conni_ng
connivances1854183connivances
conniveries1644703conniveries
conniving1537093conniving
connote9311613connote_
connoted1138863connoted
conns75024233conn___s
conoids10813883conoi_ds
conserves14311193conserves
consider11310393consider
considers1238933considers
consigns1137533consigns
consists10310593consists
consoles103216153consoles
conspires1358483conspires
consumes12310413consumes
contes84432913co_n_tes
continues11310993continues
contrive13311353contrive_
contrived1547993contrived
contriver1448343contriver
contrivers1547253contrivers
contuses10413453contuses
convenes132916913convenes
convex18367743co_n_vex
convexes20278273convexes
convey144610223co_n_vey
conveys15308223co_n_veys
convicts15337713convicts
convinces1647833convinces
convokes17247703convokes
convolves1745323convolves
cookies133719273cooki_es
coolies93824963cooli_es
coonties10513803coonties
cooties93725733cooti_es
copies104130303co_pi_es
coppices1638243coppices
corbies113520123corbi_es
cordites11314623cordites
cornice11612933cornice_
corniced1368593corniced
corniches1666673corniches
cornicles1368243cornicles
cornier93017093corni_er
corniest102117303corni_est
cornifies1439003cornifies
corniness112611183corniness
cornuses10310033cornuses
corries94026793corri_es
cortices12615013cortices
corves115122523co__rves
cosies84932153co_si_es
cosines94122673co_sines
costive12312843costive_
cotinines11410073cotinines
counties10316283counties
coves105539173co___ves
cowhides1736003cowhides
cowpies143314283cowpi_es
cowries124218013cowri_es
cowrites133011593cowrites
cozies174521413co_zi_es
crannies10313013cranni_es
crinites10612763crinites
cronies9622503croni_es
cunnings11357343cunnings
cursives1337103cursives
cyanides14258003cyanides
cyanines132710543cyanines
cyanites132610163cyanites
donatives13146903donatives
donnees84210363donn_ees
donniker1333923donniker
donnikers1443443donnikers
dunnites947173dunnites
endives113710693_endives
fannies103415643fanni_es
forgives1535753forgives
fornices1369103fornices
funnies104113603funni_es
goonies83618333gooni_es
gunnies83413123gunni_es
hinnies103615103hinni_es
hongies112716473hongi_es
honkies143015143honki_es
ionises72916433io_nises
ionizes162813343io_nizes
jennies143511623jenni_es
johnnies1872993johnni_es
knives13458553__knives
longies82916553longi_es
loonies73919543looni_es
lowlives1434573lowlives
mannites10312613mannites
minnies93617363minni_es
monies83233163mo_ni_es
motives123611893mo_tives
naives94914223__naives
nannies73015203nanni_es
ninnies73713613ninni_es
nonnatives1345643nonnatives
nonnovel1144413nonnovel
nonnovels1243443nonnovels
ogives10367913_o_gives
olives94313953_o_lives
penknives1842393penknives
pennies94218813penni_es
pennines103112043pennines
pinnies93318443pinni_es
ponies84833463po_ni_es
tennies73017973tenni_es
tennises82810133tennises
tonnages9187873tonnages
tonnes65320853tonn__es
tontines82114733tontines
toonies73719883tooni_es
townies103113623towni_es
tunnies73614263tunni_es
unlives102010953_unlives
votives13337953vo_tives

Search took 7 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 Limit1461622526.37322934.6
3Display Results2522520.1102290.9
 (SQL Overall)1786912526.63926915.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.