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

197 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
contemn113780(None) 
condemn1237111condemn
contemns1237401contemns
canteen9411082canteen
concern113011962concern
condemns1336292condemns
contain9315822contain
conte76633202conte__
contemned1446782contemned
contemner1347182contemner
contemnor1344642contemnor
contempo1444832contempo
contempt1447472contempt
contend103511892contend
content94326152content
contes84432912conte_s
contest93523232contest
context163913432context
boatmen1146913boatmen
bondmen1237893bondmen
canted94825783cante_d
canteens1038573canteens
canter85230113cante_r
canters94827723canters
canton85722993cant_on
center84421413cente_r
centers94420593centers
centime114513033centime
centimo11609543centimo
centum104012363centum_
centums11398783centums
chorten122811303chorte_n
cinema1047643cin_ema
cistern93310693cistern
cittern9339133cittern
coated94927033coate_d
coatee84327213coate_e
coatees93816533coatees
coater84329553coate_r
coaters93525773coaters
codein94916713co_dein
coden86128543co_de_n
cognomen1346083cognomen
cointer93616723cointe_r
cointers103616403cointers
coition9314313coition
colleen939533colleen
colter84625093colte_r
colters93522433colters
column1038103co_lumn
comte96125473comte__
comtes106222813comte_s
conation101420883conation
conceal113313013conceal
concede12310083concede
conceit113218063conceit
concent114422513concent
concept133314443concept
concerns122710833concerns
concert113325223concert
condemned1545093condemned
condemner1445763condemner
condemnor1443593condemnor
condign1147733condign
condom114215363condom_
condoms124214083condoms
cone67256963con_e__
coned86040053con_e_d
cones76457423con_e_s
coney105932883con_e_y
coneys115218423con_eys
confect143614273confect
confer114018683confe_r
confers124120093confers
confess12399903confess
conge85227593conge__
congeal104011683congeal
congee96024463conge_e
congeed113212303congeed
congees103517923congees
conger95024273conge_r
congers104223233congers
conges94928173conge_s
congest104618773congest
conies84338593conie_s
conin76232723con__in
conium10415313conium_
coniums11311863coniums
conjoin1638193conjoin
conked135019113conke_d
conker124721553conke_r
conkers133721043conkers
conn66229133con___n
connect113515743connect
conned95119703conne_d
conner84423963conne_r
conners94023113conners
consent93723113consent
consign1038773consign
consume11510133consume
contact1144020683contact
contains10316533contains
contemners1447073contemners
contemning1577063contemning
contemnors1445243contemnors
contempts1545063contempts
contends112810573contends
contents104018213contents
contessa1044583contessa
contests103413383contests
contexts17378653contexts
conto76027173cont__o
contort91422343contort
contos84923233cont_os
contour939963contour
contra83314693cont_ra
contras93015603contras
control9310673control
contuse9311413contuse
convect143114483convect
convene123314323convene
convent123919413convent
convert123721473convert
convex18367743conve_x
convey144610223conve_y
conveys15308223conveys
cooter85128613coote_r
cooters94525713cooters
copen94826433co_pe_n
copter109822013copte_r
copters113621273copters
cortege1098943cortege
cortex15311463corte_x
cortin82423143cort_in
costed95623113coste_d
coster84331293coste_r
costers94128303costers
costume1157853costume
cotan71521783co_t_an
cote66648733co_te__
coteau8311083co_teau
coted85033853co_te_d
cotes76347843co_te_s
cotter84926673cotte_r
cotters94323433cotters
cotton8312993co_tton
counted103815803counte_d
counter94220143counte_r
counterman1448543counterman
countermen1449293countermen
counters103320183counters
countess103710043countess
countian1048123countian
couteau938813couteau
couter84930203coute_r
couters93827283couters
coven106925043co_ve_n
cowmen13810923cowme_n
cozen165019703co_ze_n
cystein1246053cystein
footmen1246583footmen
frontmen1344423frontmen
gotten73410113gotte_n
intern64016543_intern
lantern7310013lantern
lenten6312883lente_n
molten83311813molte_n
monte75829773monte__
montero9310123montero
montes84226933monte_s
nonheme1247133nonheme
nonmen8412833nonme_n
oaten55222403_oate_n
often84611413_ofte_n
pointmen1245423pointmen
pontes83627853ponte_s
ponton83217643pont_on
pontoon93010703pontoon
posteen93512613posteen
postern93615603postern
postmen113110423postmen
poteen83514263po_teen
potmen102713093po_tmen
potteen9319673potteen
rontgen835173rontgen
rotten64115433rotte_n
routeman10135493routeman
routemen10105813routemen
soften9429493softe_n
solemn838643so_lemn
toneme8312103ton_eme
tongmen1037113tongmen
torten65314353torte_n
totem74819363to_tem_
totems86810763to_tems
wonted103213283wonte_d
wonton93410963wont_on

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.1561145455.1
2DLD Change Limit1340271976.83019623.3
3Display Results1971970.0762592.1
 (SQL Overall)1786911977.06225303.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.